Postgres Pro
Downloads
Home   >   mailing lists

User/Roles, Owner, and privileges migration strategy - Mailing list pgsql-admin

From ADITYA DUVURI
Subject User/Roles, Owner, and privileges migration strategy
Date
Msg-id CAAWjWX+4OzFiuG5S2c4iGg_p=CmLK3sf4-wMywFWqxS0OmzWBg@mail.gmail.com
Whole thread Raw
Responses Re: User/Roles, Owner, and privileges migration strategy
List pgsql-admin
Tree view
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 by date:

Previous
From: Veerendra Pulapa
Date:
Subject: Re: Need assistance for replication sync issue
Next
From: vrms
Date:
Subject: Re: using pg_ctl over ssh hangs