|OS type and version
||Debian Linux 11
||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.