pg_dumpall on the PostgreSQL database

[seethro]

Hello,

I love the Borg backup feature, but I'd really like to do a pg_dumpall on the db.

From my docker host, when I run:
sudo docker exec -t nextcloud-aio-database pg_dumpall -c -U postgres > dump_aio_db.sql

I get something like this in the .sql file:
pg_dumpall: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist

I'm a docker noob so please be gentle...

[szaimen]

Simply run this inside the database container?

all-in-one/Containers/postgresql/start.sh

Line 114 in bad4319

if pg_dump --username "$POSTGRES_USER" "$POSTGRES_DB" > "$DUMP_FILE.temp"; then

[seethro]

Thanks for the tip... looks like I was using the wrong user!!
This worked for me:
docker exec -it nextcloud-aio-database pg_dump -U nextcloud nextcloud_database