autobase: Unable to access psql terminal
Hello,
I am getting following error when trying to access psql terminal. This happens on all nodes Is it cause of using different default username in vars/main.yml file
patroni_superuser_username: "patroni_usr"
root@pgsql01:~# sudo -u postgres psql
could not change directory to "/root": Permission denied
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist
root@pgsql01:~#
root@pgsql01:~# ls -alh /var/run/postgresql/.s.PGSQL.5432
srwxrwxrwx 1 postgres postgres 0 Apr 25 14:26 /var/run/postgresql/.s.PGSQL.5432
root@pgsql01:~#
Thank you.
About this issue
- Original URL
- State: closed
- Created 5 years ago
- Comments: 18 (10 by maintainers)
ok I’ll fix it