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