But there isn’t a postgres password because it requires being a superuser: the pg_hba.conf file has “local” connection permissions set to “peer”, so it depends on the UNIX user, which requires logging via SSH, no?
This doesn’t work: psql -h XX.XX.XX.XX -p 5432 -U postgres -d discourse