i have a database postgis , now i have taken dump from it to restore on percona postgres db but i face issue in extensions of postgis on percona
i tried to install the extensions manually i failed
is there solution can i do from Helm to fix it
HI,
There’s a few ways to install a postgis enabled database to another cluster.
One problematic issue has to do with the version differences. Ideally, you are using the same major and minor version of postgis between data clusters otherwise you run into conflicts if the TARGET data cluster uses a version that’s different from the SRC data cluster.
Another issue is to remember that extensions can add functions, sequences, indexes, tables, data types etc. Problems can occur If you dump the individual objects instead of allowing the extension to create them instead.
To help you further requires reviewing the postgres logs on the target host.
Hope this helps
can you share an link or documntation that can help in this that i can follow