| 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.
| 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 |