[Top][All Lists]

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

Re: Doc bug: Postgres account not available

From: Gábor Boskovits
Subject: Re: Doc bug: Postgres account not available
Date: Mon, 8 Jun 2020 07:40:15 +0200

Hello Pierre,

This has been this way for a while. It took me some time to  find it
out also. I guess that documenting it would be fine.
Most of the times I finally end up adding a shell to the account, but
keeping it this way is a sane default when you automanage your

Pierre Neidhardt <> ezt írta (időpont: 2020. máj.
23., Szo, 16:47):
> Hi!
> 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

Best regards,
OpenPGP Key Fingerprint: 7988:3B9F:7D6A:4DBF:3719:0367:2506:A96C:CF63:0B21

reply via email to

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