best migration solution

Поиск
Список
Период
Сортировка
От Zwettler Markus (OIZ)
Тема best migration solution
Дата
Msg-id GV0P278MB0099D9368CEBEBF304405F778B172@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: best migration solution
Re: best migration solution
Re: best migration solution
Список pgsql-general

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

  • exclude roles not needed
  • change required role names

 

dump all required databases with pg_dump

  • in plain text
  • exclude all schemas not needed

edit this dump file and

  • exclude any "create extension" command for not existing extensions
  • change all required role names on permissions and ownerships

 

 

any missings?
any better solutions?

 

 

I wonder whether a plain text dump could lead to conversion problems or something similar?

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Kashif Zeeshan
Дата:
Сообщение: Re: What linux version to install ?
Следующее
От: Kashif Zeeshan
Дата:
Сообщение: Re: best migration solution