unofficial mirror of help-guix@gnu.org 
 help / color / Atom feed
* Doc bug: Postgres account not available
@ 2020-05-23 14:47 Pierre Neidhardt
  2020-06-08  5:40 ` Gábor Boskovits
  0 siblings, 1 reply; 3+ messages in thread
From: Pierre Neidhardt @ 2020-05-23 14:47 UTC (permalink / raw)
  To: help-guix

[-- Attachment #1: Type: text/plain, Size: 1089 bytes --]

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 https://issues.guix.info/38198.
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
https://ambrevar.xyz/

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 487 bytes --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: Doc bug: Postgres account not available
  2020-05-23 14:47 Doc bug: Postgres account not available Pierre Neidhardt
@ 2020-06-08  5:40 ` Gábor Boskovits
  2020-06-10  9:32   ` Pierre Neidhardt
  0 siblings, 1 reply; 3+ messages in thread
From: Gábor Boskovits @ 2020-06-08  5:40 UTC (permalink / raw)
  To: Pierre Neidhardt; +Cc: help-guix

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
database.

Pierre Neidhardt <mail@ambrevar.xyz> 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 https://issues.guix.info/38198.
> 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
> https://ambrevar.xyz/


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


^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: Doc bug: Postgres account not available
  2020-06-08  5:40 ` Gábor Boskovits
@ 2020-06-10  9:32   ` Pierre Neidhardt
  0 siblings, 0 replies; 3+ messages in thread
From: Pierre Neidhardt @ 2020-06-10  9:32 UTC (permalink / raw)
  To: Gábor Boskovits; +Cc: help-guix

[-- Attachment #1: Type: text/plain, Size: 115 bytes --]

Doc update patch sent here: https://issues.guix.info/issue/41786.

-- 
Pierre Neidhardt
https://ambrevar.xyz/

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 487 bytes --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, back to index

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2020-05-23 14:47 Doc bug: Postgres account not available Pierre Neidhardt
2020-06-08  5:40 ` Gábor Boskovits
2020-06-10  9:32   ` Pierre Neidhardt

unofficial mirror of help-guix@gnu.org 

Archives are clonable:
	git clone --mirror https://yhetil.org/guix-user/0 guix-user/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 guix-user guix-user/ https://yhetil.org/guix-user \
		help-guix@gnu.org
	public-inbox-index guix-user

Example config snippet for mirrors

Newsgroups are available over NNTP:
	nntp://news.yhetil.org/yhetil.gnu.guix.user
	nntp://news.gmane.io/gmane.comp.gnu.guix.user


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git