Date: Sat, 14 Jun 2025 10:42:59 +0200 (CEST)
From: Rachel Roch <rroch@tutanota.de>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	Pgsql General <pgsql-general@lists.postgresql.org>
Message-ID: <OShaniJ--F-9@tutanota.de>
In-Reply-To: <e12c9b8d-0d77-4462-9f52-06376d5f9d65@aklaver.com-OSehXyh----9>
References: <OSeT_Gx--F-9@tutanota.de> <1407215.1749838987@sss.pgh.pa.us> <e12c9b8d-0d77-4462-9f52-06376d5f9d65@aklaver.com-OSehXyh----9>
Subject: Re: pg_restore ERROR: permission denied to change default
 privileges
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/OShaniJ--F-9%40tutanota.de>
Precedence: bulk


13 Jun 2025, 20:13 by adrian.klaver@aklaver.com:

>
> To get at an editable script you can do something like:
>
> pg_restore -f my_database_txt.sql  my_database.dump
>
> This will give you a plain text version of the dump that you can feed bac=
k to psql to load into remote database.
>

Thanks Adrian !

I had thought maybe maybe I could do a "pg_restore -l=C2=A0my_database.dump=
" and ignore the relevant line using whatever the other flag is, but sadly =
there doesn't appear to be enough flexibility, i.e.=C2=A0

pg_restore -l=C2=A0my_database.dump | fgrep -F postgres
gives:
2067; 826 16607 DEFAULT ACL public DEFAULT PRIVILEGES FOR TABLES postgres

But

pg_restore -l=C2=A0my_database.dump | fgrep -F=C2=A0my_database_ro
gives nothing.=C2=A0 =C2=A0:(

So either your solution or Tom's "just ignore it" sound like they'll work.