[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Doc bug: Postgres account not available

From: Pierre Neidhardt
Subject: Doc bug: Postgres account not available
Date: Sat, 23 May 2020 16:47:12 +0200


Apparently our Postgres service changed a little bit recently.  While it
was easy to setup in the past, this week it cost me a few hours, trying
to figure out how to do a simple thing like

--8<---------------cut here---------------start------------->8---
$ psql -U postgres
psql: FATAL:  Peer authentication failed for user "postgres"
--8<---------------cut here---------------end--------------->8---

Eventually, I discovered
Turns out the authentication policy is now "peer" and the shell-less
'postgres' user cannot be used without a shell.

As such, to administrate PostgresQL we need first to switch to the
postgres user as follows:

--8<---------------cut here---------------start------------->8---
  sudo su postgres -s psql
--8<---------------cut here---------------end--------------->8---

This was not a very obvious find on the Internet.
Can we make this easier?  The above thread suggests to leave the setup
as is and to document it.

Thoughts?  Gábor, Giovanni?

Pierre Neidhardt

Attachment: signature.asc
Description: PGP signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]