Re: pg_restore ERROR: permission denied to change default privileges

2025-06-14 Thread Adrian Klaver
On 6/14/25 01:42, Rachel Roch wrote: 13 Jun 2025, 20:13 by adrian.kla...@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 back to psql to load int

Re: pg_restore ERROR: permission denied to change default privileges

2025-06-14 Thread Rachel Roch
13 Jun 2025, 20:13 by adrian.kla...@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 back to > psql to load into remote database. > Thanks