From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 8C0cNII3yV5lHQAA0tVLHw (envelope-from ) for ; Sat, 23 May 2020 14:47:30 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id zxP+L4I3yV7eTwAAB5/wlQ (envelope-from ) for ; Sat, 23 May 2020 14:47:30 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 48ECF9404D3 for ; Sat, 23 May 2020 14:47:30 +0000 (UTC) Received: from localhost ([::1]:58216 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jcVQu-0002ko-Uo for larch@yhetil.org; Sat, 23 May 2020 10:47:28 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:34722) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jcVQo-0002kg-BF for help-guix@gnu.org; Sat, 23 May 2020 10:47:22 -0400 Received: from relay9-d.mail.gandi.net ([217.70.183.199]:60841) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jcVQn-0003I8-6J for help-guix@gnu.org; Sat, 23 May 2020 10:47:21 -0400 X-Originating-IP: 78.248.96.161 Received: from mimimi (mqu44-1-78-248-96-161.fbx.proxad.net [78.248.96.161]) (Authenticated sender: mail@ambrevar.xyz) by relay9-d.mail.gandi.net (Postfix) with ESMTPSA id A108FFF802; Sat, 23 May 2020 14:47:13 +0000 (UTC) From: Pierre Neidhardt To: help-guix@gnu.org Subject: Doc bug: Postgres account not available Date: Sat, 23 May 2020 16:47:12 +0200 Message-ID: <87o8qeiu8f.fsf@ambrevar.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" Received-SPF: pass client-ip=217.70.183.199; envelope-from=mail@ambrevar.xyz; helo=relay9-d.mail.gandi.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/05/23 10:36:08 X-ACL-Warn: Detected OS = Linux 3.11 and newer X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: help-guix@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-guix-bounces+larch=yhetil.org@gnu.org Sender: "Help-Guix" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of help-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=help-guix-bounces@gnu.org X-Spam-Score: -3.11 X-TUID: 4KuLltqJ0238 --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 =2D-8<---------------cut here---------------start------------->8--- $ psql -U postgres psql: FATAL: Peer authentication failed for user "postgres" =2D-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: =2D-8<---------------cut here---------------start------------->8--- sudo su postgres -s psql =2D-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=C3=A1bor, Giovanni? =2D-=20 Pierre Neidhardt https://ambrevar.xyz/ --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEUPM+LlsMPZAEJKvom9z0l6S7zH8FAl7JN3AACgkQm9z0l6S7 zH+ORAf+JtcpEwfFw/tcFq2Atnro02kKB1cPiRRX1vscDnRLaanrx3lXCDZkPF9U IK0r3WDBbQcHQOKjgQFquwBndLSIc7K6TGtTC+oL3ilSLN8mFTsDUjgQm7ULAvxL ZWNu7V8wRohbvvzWIBt+fw9QUquq8C5EJE0EWPCL3in+f8me2p85w+QKLNeJJJ1z QSJG9oNkFdGrKgofT99P6CIYnuEa4xVWmfuf63v37ZCRcbQfHvvEgkORP/7qD6n/ oXp2IcRtmmnU0lmtJnzm5aRFoDWGA7xoT+PndNP91vdomUZOHOt0no4Qin/eXWHL SeCAaStYDknXYQntv8zTKuFLvBRIYA== =77cI -----END PGP SIGNATURE----- --=-=-=--