PostgreSQL backup script

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