Re: pg_restore ERROR: permission denied to change default privileges

From: Rachel Roch <rroch(at)tutanota(dot)de>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore ERROR: permission denied to change default privileges
Date: 2025-06-14 08:42:59
Message-ID: OShaniJ--F-9@tutanota.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

13 Jun 2025, 20:13 by adrian(dot)klaver(at)aklaver(dot)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 back to psql to load into remote database.
>

Thanks Adrian !

I had thought maybe maybe I could do a "pg_restore -l my_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. 

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

But

pg_restore -l my_database.dump | fgrep -F my_database_ro
gives nothing.   :(

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-06-14 15:21:19 Re: pg_restore ERROR: permission denied to change default privileges
Previous Message Adrian Klaver 2025-06-13 19:13:09 Re: pg_restore ERROR: permission denied to change default privileges