PostgreSQL Database Server Module: backup problem

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

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

Status:
Active
»
Closed (works as designed)

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