User/Roles, Owner, and privileges migration strategy

From: ADITYA DUVURI <adilove1987(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: User/Roles, Owner, and privileges migration strategy
Date: 2023-10-20 10:20:35
Message-ID: CAAWjWX+4OzFiuG5S2c4iGg_p=CmLK3sf4-wMywFWqxS0OmzWBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message vrms 2023-10-20 13:55:23 Re: using pg_ctl over ssh hangs
Previous Message Veerendra Pulapa 2023-10-20 04:10:58 Re: Need assistance for replication sync issue