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)

Most upvoted comments

ok I’ll fix it