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 yBR6K9pYHV/jDAAA0tVLHw (envelope-from ) for ; Sun, 26 Jul 2020 10:20:10 +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 sAlWJ9pYHV/9GwAAB5/wlQ (envelope-from ) for ; Sun, 26 Jul 2020 10:20:10 +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 3B5B39403EC for ; Sun, 26 Jul 2020 10:20:10 +0000 (UTC) Received: from localhost ([::1]:43190 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jzdlJ-0008DL-6k for larch@yhetil.org; Sun, 26 Jul 2020 06:20:09 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:35534) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jzdlC-0008D0-Rv for guix-patches@gnu.org; Sun, 26 Jul 2020 06:20:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:40278) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jzdlC-0008MK-Ic for guix-patches@gnu.org; Sun, 26 Jul 2020 06:20:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1jzdlC-00062F-E9 for guix-patches@gnu.org; Sun, 26 Jul 2020 06:20:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. Resent-From: Pierre Neidhardt Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Sun, 26 Jul 2020 10:20:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 41786 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: Oleg Pykhalov Cc: 41786@debbugs.gnu.org Received: via spool by 41786-submit@debbugs.gnu.org id=B41786.159575874223126 (code B ref 41786); Sun, 26 Jul 2020 10:20:02 +0000 Received: (at 41786) by debbugs.gnu.org; 26 Jul 2020 10:19:02 +0000 Received: from localhost ([127.0.0.1]:51824 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jzdkE-00060w-GA for submit@debbugs.gnu.org; Sun, 26 Jul 2020 06:19:02 -0400 Received: from relay8-d.mail.gandi.net ([217.70.183.201]:40199) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jzdkC-00060Q-Ud for 41786@debbugs.gnu.org; Sun, 26 Jul 2020 06:19:01 -0400 X-Originating-IP: 86.246.37.13 Received: from bababa (lfbn-idf2-1-572-13.w86-246.abo.wanadoo.fr [86.246.37.13]) (Authenticated sender: mail@ambrevar.xyz) by relay8-d.mail.gandi.net (Postfix) with ESMTPSA id 1A5731BF209; Sun, 26 Jul 2020 10:18:53 +0000 (UTC) From: Pierre Neidhardt In-Reply-To: <87blk3l8a7.fsf@gmail.com> References: <20200610093147.24347-1-mail@ambrevar.xyz> <87blk3l8a7.fsf@gmail.com> Date: Sun, 26 Jul 2020 12:18:53 +0200 Message-ID: <878sf6mvea.fsf@ambrevar.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" X-Spam-Score: -0.2 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -0.2 (/) X-BeenThere: guix-patches@gnu.org List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-patches-bounces+larch=yhetil.org@gnu.org Sender: "Guix-patches" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-patches-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-patches-bounces@gnu.org X-Spam-Score: -3.11 X-TUID: X6cVGc2nlZEm --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Oleg Pykhalov writes: > Every =E2=80=98guix system reconfigure=E2=80=99 I see a message about > =E2=80=9C/var/lib/postgresql/ already exists, skipping creating=E2=80=9D = if I remember > correctly. Do you see this when you use a cluster?=20=20 Yes. > I don't have a strong opinion for this, but the message is enough, isn't > it? Maybe we could say in the documentation to remove data directory in > any case when you don't need previous data? I don't find the message explicit enough, in particular it does not explain that the existing data could cause Postgres to fail. Finally, it's easy to miss the message in this wall of text. > I tried =E2=80=98sudo su postgres -s /bin/sh=E2=80=99, then: > --8<---------------cut here---------------start------------->8--- > sh-5.0$ createuser --interface > sh: createuser: command not found > --8<---------------cut here---------------end--------------->8--- > > First of all we could use just =E2=80=98sudo=E2=80=99 to get a shell: > > sudo -u postgres -s /bin/sh I thought I had tried this and it didn't work for whatever reason. I'll test again. > =E2=80=98createuser=E2=80=99 and =E2=80=98createdb=E2=80=99 are in =E2=80= =98/gnu/store/=E2=80=A6-postgresql-10.13/bin=E2=80=99, > which is missing in my =E2=80=98postgres=E2=80=99 user's profile. Right, I have postgresql installed in my user profile. > To fix this we could make =E2=80=98postgres=E2=80=99 available by default= as in > https://git.savannah.gnu.org/cgit/guix.git/commit/?id=3Ddb65d7447c3adc46e= 2b24abfc07ae10c6c537df4 I think you meant the postgresql package. Indeed, that would fix it. However this means we are "polluting" all user profiles with executables that are not necessarily wanted by everyone. Is this desirable? =2D-=20 Pierre Neidhardt https://ambrevar.xyz/ --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEUPM+LlsMPZAEJKvom9z0l6S7zH8FAl8dWI0ACgkQm9z0l6S7 zH/99ggAogstqA0Rlo2yYvwxR1qAMxeZgN+kUinwb5VNZnOICG+R6fs9oPaQJfnl EGz5oqY0dOPFTC8a3TQXYcbGpJAWw/zMxl2k6/SiLy8QOX77EJL6tYeq05NMGcyw T6NHwGuTLRbtf5gevfP4KuXlLd0umA9HsOd3egTcT9+XDWEr+qU03M8FHzwOZTR7 Otm55WlCiZO5cHboiOWv2IMCKXmMQwkZEZ8uNuKzv1tUEhCPX6PIhIVZBiCz8azf ty+3wK6CUGhTBEtM86nZYVaB/MAfGjzQZpNNtZQ4s9l9//KzFMpPEqaAK0wfM6VI sbfyFN/ymw2K2rf4IVVvA2dLvXUWtw== =laxk -----END PGP SIGNATURE----- --=-=-=--