Page 1 of 1

PostgreSQL backup script

Posted: Fri May 09, 2025 8:59 pm
by nets
Doing a PostgreSQL (v11) backup script, and having trouble with

Code: Select all

pg_dump: could not open large object 100000: ERROR:  permission denied for large object 100000
Whats the right way to handle this? Turn on lo_compat_privileges in postgresql.conf or do you have another way?
Script is basically the postgresql.org cmd script for windows.

Re: PostgreSQL backup script

Posted: Thu May 15, 2025 6:47 pm
by Tommy.c
I am talking to our internal DB guys to figure out what our recommendation for this would be.

My googling has me think that you should be fine with setting your PostgreSQL "lo_compat_privileges = on" and he should be good to go.

But I am going to double check myself. Stay tuned.