Postgresql backup lacks permissions

OS type and version Debian Linux 11
Webmin version 2.101
Usermin version 2.001
Virtualmin version 7.8.2
Theme version 21.04
Package updates All installed packages are up to date

Seems I’ve always had some ‘issues’ with permissions on postgres, especially with root access being denied. I’m not sure the template db is supposed to be accepting connections. I’m only showing this part but all of my sites are basically ‘Permission denied’.

Using the Webmin postgres module.


As time permits.
root@main:~# psql psql: error: FATAL: role "root" does not exist

root@main:~# su postgres

could not change directory to "/root": Permission denied
psql (13.11 (Debian 13.11-0+deb11u1))
Type "help" for help.


Not just the interface. Scheduled fails too. I have it set to mail on error:
Backup of database ycc to file /home/backup/postgresql/ycc.sql failed:
bash: line 1: /home/backup/postgresql/ycc.sql: Permission denied

If I su postgres from the command line I can do a pg_dumpall. I guess I couldn’t run it from the directory I was in previous.