From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
---|---|
To: | ADITYA DUVURI <adilove1987(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: User/Roles, Owner, and privileges migration strategy |
Date: | 2023-10-20 14:57:32 |
Message-ID: | DM4PR19MB597814BDE702C5FC0CA60160D3DBA@DM4PR19MB5978.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)com>
Sent: Friday, October 20, 2023 6:20 AM
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | M Sarwar | 2023-10-21 15:07:01 | Need to run pg_dump from the laptop without entering the password |
Previous Message | vrms | 2023-10-20 13:55:23 | Re: using pg_ctl over ssh hangs |