Aleksandar Dimitrijevic
Aleksandar Dimitrijevic
PostsComments
PPrisma
Created by Aleksandar Dimitrijevic on 12/5/2024 in #help-and-questions
Wrong connection pool info ??
No description
8 replies
PPrisma
Created by Aleksandar Dimitrijevic on 11/21/2024 in #help-and-questions
Postgis verstion update
Hello, How can I update from version 3.2.4 postgis to 3.2.6. 3.2.4 is currently in my database and that version is not existing anywhere now. So if I want to deploy my migrations on staging environment i have a problem 
DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E22023), message: "extension \"postgis\" has no installation script nor update path for version \"3.2.4\"", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("extension.c"), line: Some(1535), routine: Some("CreateExtensionInternal
DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E22023), message: "extension \"postgis\" has no installation script nor update path for version \"3.2.4\"", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("extension.c"), line: Some(1535), routine: Some("CreateExtensionInternal
3.2.6 is next available Is there a way to somehow change 3.2.4 to 3.2.6 in already created migration and do not mess up my data on production env ? Or what is a solution
3 replies
PPrisma
Created by Aleksandar Dimitrijevic on 11/1/2024 in #help-and-questions
In one of my migration i have
-- CreateExtension
CREATE EXTENSION IF NOT EXISTS "postgis" WITH VERSION "3.2.4";
-- CreateExtension
CREATE EXTENSION IF NOT EXISTS "postgis" WITH VERSION "3.2.4";
But that version is not supported anymore, so i have problem with generation new migrations, bcs shadow database cannot be created bcs 3.2.4 version is not supported anymore and i cannot just change to 3.2.6 bcs migration is not same as it was . What should I do, to succesfully update postgis to for example next min version 3.2.6?
1 replies