|
I do not know what is your source database.
In postgres, roles are instance basis unlike database basis in other database flavours.
Good luck,
Sarwar
From: ADITYA DUVURI <adilove1987@xxxxxxxxx>
Sent: Friday, October 20, 2023 6:20 AM To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx> Subject: User/Roles, Owner, and privileges migration strategy 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
|
