we have to migrate from hosted PG12 to containerized PG16 on private cloud. some of the installed PG12 extensions are not offered on the containerized PG16, eg. PostGIS related extensions like pg_routing and ogr_fdw. some of these extensions are not needed anymore. some of these extensions were installed in their own schema. we also need to change the database names and most role names due to external requirements. I came up with this solution. dump all roles with pg_dumpall.edit this dumpfile andexclude roles not neededchange required role names dump all required databases with pg_dump in plain textexclude all schemas not needededit this dump file andexclude any "create extension" command for not existing extensionschange all required role names on permissions and ownerships any missings? any better solutions?
we have to migrate from hosted PG12 to containerized PG16 on private cloud.
some of the installed PG12 extensions are not offered on the containerized PG16, eg. PostGIS related extensions like pg_routing and ogr_fdw.
some of these extensions are not needed anymore. some of these extensions were installed in their own schema. we also need to change the database names and most role names due to external requirements.
I came up with this solution.
dump all roles with pg_dumpall.
edit this dumpfile and
dump all required databases with pg_dump
edit this dump file and
any missings? any better solutions?
I wonder whether a plain text dump could lead to conversion problems or something similar?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
