PostgreSQL Database Server Module: backup problem

Submitted by sennalb on Tue, 07/07/2020 - 14:37

If I schedule a backup al a single DB o for all Database or with a Run now backup i have an error

Failed to backup database : pg_dump failed :

pg_dump: [archiviatore] apertura del file di output "/var/backups/dbcyclo.sql" fallita: Permesso negato

Failed to backup database : pg_dump failed :

pg_dump: [archiviatore] apertura del file di output "/var/backups/postgres.sql" fallita: Permesso negato

Database template0 is not accepting connections.

Failed to backup database : pg_dump failed :

pg_dump: [archiviatore] apertura del file di output "/var/backups/template1.sql" fallita: Permesso negato

Scheduled backup path, format and times for database updated.

I have PostgreSQL version 11.7 (With schemas) on Webmin version 1.953 Authentic theme version 19.52

Status: 
Closed (works as designed)

Comments

Submitted by JamieCameron on Fri, 07/10/2020 - 20:28

Is the directory /var/backups writable by the postgres user that the database runs as?

Submitted by sennalb on Sat, 07/11/2020 - 04:11

Hi Jamie, Sorry, you're right, I thought pg_dump was managed by root, creating a directory owned by postgres it all ok Thanks Alberto