Code: Select all
pg_dump: could not open large object 100000: ERROR: permission denied for large object 100000Script is basically the postgresql.org cmd script for windows.
PostgreSQL backup script
Doing a PostgreSQL (v11) backup script, and having trouble with
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.
Script is basically the postgresql.org cmd script for windows.
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.
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.