Re: pg_restore: error: could not execute query: ERROR: must be member of role "postgres"

On 3/21/24 08:15, Cappellano, John (MMA) wrote:
> All,
> 
> I am a novice at Postgres (no experience). We have a VM Amazon Postgres 
> Instance running v13. I am trying to do a pg_dump from it and restore it 
> to Azure PAAS Postgres v11 environment. I keep getting the following error:
> 
> pg_restore: error: could not execute query: ERROR: must be member of 
> role "postgres"
> 
> The DB on the VM:
> 
> The DB on Azure PAAS:
> 
> I have tried to do a pg_dump with the -O (no owner) but the restore 
> still fails with the same error.
> 
> I have also tried to change the owner of the Azure DB to postgres but I 
> get this error:
> 
> First question,
> 
> Can I restore a higher version of Postgreg to a lower version?
> 
> Can someone help get me past this issue?

Yes, but not on this list.

The appropriate list for this sort of question is:

https://www.postgresql.org/list/pgsql-general/

pgsql-www is for:

"Discussion of development and coordination of the PostgreSQL websites."

> 
> I appreciate any assistance.
> 
> Thanks
> 
> *John Cappellano*
> 
> *Database Administration*
> 
> Marsh & McLennan Agency LLC
> 
> (610) 506-0287 cell
> 
> john.cappellano@marshmma.com <mailto:john.cappellano@marshmma.com> | 
> www.marshmma.com <http://www.marshmma.com/>
> 
> A business of Marsh McLennan
> Marsh & McLennan Agency LLC
> 
> 
> ------------------------------------------------------------------------
> 
> This e-mail transmission and any attachments that accompany it may 
> contain information that is privileged, confidential or otherwise exempt 
> from disclosure under applicable law and is intended solely for the use 
> of the individual(s) to whom it was intended to be addressed. If you 
> have received this e-mail by mistake, or you are not the intended 
> recipient, any disclosure, dissemination, distribution, copying or other 
> use or retention of this communication or its substance is prohibited. 
> If you have received this communication in error, please immediately 
> reply to the author via e-mail that you received this message by mistake 
> and also permanently delete the original and all copies of this e-mail 
> and any attachments from your computer.
> 
> Please note that coverage cannot be bound or altered by sending an 
> email. You must speak with or receive written confirmation from a 
> licensed representative of our firm to put coverage in force or make 
> changes to your existing program. Thank you.

-- 
Adrian Klaver
adrian.klaver@aklaver.com