Postgres Pro
Downloads
Home   >   mailing lists

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

From M Sarwar
Subject Re: User/Roles, Owner, and privileges migration strategy
Date
Msg-id DM4PR19MB597814BDE702C5FC0CA60160D3DBA@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
In response to User/Roles, Owner, and privileges migration strategy  (ADITYA DUVURI <adilove1987@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com>
Sent: Friday, October 20, 2023 6:20 AM
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
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

pgsql-admin by date:

Previous
From: vrms
Date:
Subject: Re: using pg_ctl over ssh hangs
Next
From: M Sarwar
Date:
Subject: Need to run pg_dump from the laptop without entering the password