User/Roles, Owner, and privileges migration strategy

Поиск
Список
Период
Сортировка
От ADITYA DUVURI
Тема User/Roles, Owner, and privileges migration strategy
Дата
Msg-id CAAWjWX+4OzFiuG5S2c4iGg_p=CmLK3sf4-wMywFWqxS0OmzWBg@mail.gmail.com
обсуждение исходный текст
Ответы Re: User/Roles, Owner, and privileges migration strategy  (M Sarwar <sarwarmd02@outlook.com>)
Список pgsql-admin
Hi Team,

Can you please let us know what is the best strategy or different approaches to migrate users/roles, privileges and owner to different PaaS PostgreSQL instance like AWS RDS or GCP cloud SQL from on-premises? There are different use cases and how this can be handled like “Alter Owner” of an object runs first before grant all privileges in pg_dump and it fails in the PaaS services.

Thanks & Regards,
Aditya

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

Предыдущее
От: Veerendra Pulapa
Дата:
Сообщение: Re: Need assistance for replication sync issue
Следующее
От: vrms
Дата:
Сообщение: Re: using pg_ctl over ssh hangs