From debbugs-submit-bounces@debbugs.gnu.org Wed Jun 10 05:31:57 2020 Received: (at submit) by debbugs.gnu.org; 10 Jun 2020 09:31:57 +0000 Received: from localhost ([127.0.0.1]:33436 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jix5R-0006hZ-Gu for submit@debbugs.gnu.org; Wed, 10 Jun 2020 05:31:57 -0400 Received: from lists.gnu.org ([209.51.188.17]:60170) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jix5Q-0006hR-KC for submit@debbugs.gnu.org; Wed, 10 Jun 2020 05:31:57 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:49526) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jix5Q-0000or-Dc for guix-patches@gnu.org; Wed, 10 Jun 2020 05:31:56 -0400 Received: from relay10.mail.gandi.net ([217.70.178.230]:47379) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jix5P-0007vC-7F for guix-patches@gnu.org; Wed, 10 Jun 2020 05:31:55 -0400 Received: from localhost.localdomain (lfbn-idf2-1-1315-147.w92-169.abo.wanadoo.fr [92.169.129.147]) (Authenticated sender: mail@ambrevar.xyz) by relay10.mail.gandi.net (Postfix) with ESMTPSA id DB6C8240006 for ; Wed, 10 Jun 2020 09:31:47 +0000 (UTC) From: Pierre Neidhardt To: guix-patches@gnu.org Subject: [PATCH] doc: Explain how to use psql with peer authentication. Date: Wed, 10 Jun 2020 11:31:47 +0200 Message-Id: <20200610093147.24347-1-mail@ambrevar.xyz> X-Mailer: git-send-email 2.26.2 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=217.70.178.230; envelope-from=mail@ambrevar.xyz; helo=relay10.mail.gandi.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/06/10 03:51:35 X-ACL-Warn: Detected OS = Linux 3.11 and newer X-Spam_score_int: -15 X-Spam_score: -1.6 X-Spam_bar: - X-Spam_report: (-1.6 / 5.0 requ) BAYES_00=-1.9, FROM_SUSPICIOUS_NTLD=1, FROM_SUSPICIOUS_NTLD_FP=1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-1, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-Spam-Score: 0.9 (/) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.1 (--) * doc/guix.texi (Database Services): Add example of shell commands to use psql as system user. Also add troubleshooting tip when service fails to start because of incompatible cluster. --- doc/guix.texi | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/doc/guix.texi b/doc/guix.texi index 15e077a41c..1326be69e5 100644 --- a/doc/guix.texi +++ b/doc/guix.texi @@ -16787,6 +16787,24 @@ The PostgreSQL daemon loads its runtime configuration from @var{config-file}, creates a database cluster with @var{locale} as the default locale, stored in @var{data-directory}. It then listens on @var{port}. +If the services fails to start, it may be due to an incompatible +cluster already present in @var{data-directory}. Adjust it (or, if you +don't need the cluster anymore, delete @var{data-directory}), then +restart the service. + +Peer authentication is used by default and the @code{postgres} user +account has no shell, which prevents the direct execution of @code{psql} +commands as this user. To use @code{psql}, you can temporarily log in +as @code{postgres} using a shell, create a PostgreSQL superuser with the +same name as one of the system users and then create the associated +database. + +@example +sudo su postgres -s /bin/sh +createuser --interface +createdb $MY_USER_LOGIN # Replace appropriately. +@end example + @cindex postgresql extension-packages Additional extensions are loaded from packages listed in @var{extension-packages}. Extensions are available at runtime. For instance, -- 2.26.2 From debbugs-submit-bounces@debbugs.gnu.org Sat Jul 25 15:11:24 2020 Received: (at 41786) by debbugs.gnu.org; 25 Jul 2020 19:11:24 +0000 Received: from localhost ([127.0.0.1]:51164 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jzPZs-0000tE-GT for submit@debbugs.gnu.org; Sat, 25 Jul 2020 15:11:24 -0400 Received: from mail-lj1-f195.google.com ([209.85.208.195]:45112) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jzPZq-0000t0-NJ for 41786@debbugs.gnu.org; Sat, 25 Jul 2020 15:11:23 -0400 Received: by mail-lj1-f195.google.com with SMTP id r19so13191411ljn.12 for <41786@debbugs.gnu.org>; Sat, 25 Jul 2020 12:11:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=qIQmLU1ZoRVV3iCvijy9g/KjtAbKNtKlG+u3aBtCfKQ=; b=MkYAtNovFXcN8fz38QCl89BDWRKjL7BO6Y3ZYmJ6U5QIRIeAbI592xO9F8F/NjVcAc zmMg91aSa86hqh15AEQL6GQrHLFb0z/UnzMX2y7LbaZ0dKmLvGe+BtoLYbywJpQl0yfn bE/6SosdvifAIObqp8LZ6SOVhd1oSeR+TfpNPGaBinJ1LNpUut/dcy5EZkVF6kgOZ8gF wiismJefhWc/g7g6KkiFzSiPC9G/s46T536ZMANF0sdl3rYbBxlrbKj5wnB9HC1hB7HW UGkZdSmAiPriNAoac3lYhqXwdgRLlryBOi9TL+HsztL9MjU9hEolc73dZs1VEMfuUozK Fa3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=qIQmLU1ZoRVV3iCvijy9g/KjtAbKNtKlG+u3aBtCfKQ=; b=cvpW8PCnKeuO1bfoaMMLaXBLYWnSjIvh3SvoB5VKe2Eap5Jns87Lw1ohLE8x4p1hkG OSvdqVCgG8W3XXk1rnRQDGUrYsrCYIevNtcB4IfOzUgI95JVrkQRxtgBA3v3psRizQsP rbIIIyhkBxWtt9L/rLcsZ43R2AF4tw69/woSTjIWhqCWXYJEq55HEFVGVQw7VEB0Iq4a VZ7PSqS0UvGXdgJvjzMaS+Q0TwrxciAi3LguRcPPWiXHIGz6DYNa+FnH5TYu5LcYxC80 laGtk6sHrdvewrabqhVGbJtVyXt3xvrKqkTSWZquip22tZji1oOsn0dbu8WDnCe8vhMA yXIw== X-Gm-Message-State: AOAM533Xd7NDhvC63M14yE4UvTtJr6BeeP8nMXxCvuortiKurRKfHIJ2 GuePMicz6AOYtgAawguZJhclyE2E X-Google-Smtp-Source: ABdhPJzSqjwrem5fyXWY2Uz5ujtA5v6x0/xatux0wtWPey+eUQ8RHJbhYm+t3dApHPNZKpbLL6vATg== X-Received: by 2002:a2e:504f:: with SMTP id v15mr1544358ljd.347.1595704276281; Sat, 25 Jul 2020 12:11:16 -0700 (PDT) Received: from guixsd (ppp91-122-98-213.pppoe.avangarddsl.ru. [91.122.98.213]) by smtp.gmail.com with ESMTPSA id n3sm1246146ljj.39.2020.07.25.12.11.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 25 Jul 2020 12:11:15 -0700 (PDT) From: Oleg Pykhalov To: Pierre Neidhardt Subject: Re: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. References: <20200610093147.24347-1-mail@ambrevar.xyz> Date: Sat, 25 Jul 2020 22:11:12 +0300 In-Reply-To: <20200610093147.24347-1-mail@ambrevar.xyz> (Pierre Neidhardt's message of "Wed, 10 Jun 2020 11:31:47 +0200") Message-ID: <87blk3l8a7.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 41786 Cc: 41786@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Pierre, Pierre Neidhardt writes: > * doc/guix.texi (Database Services): Add example of shell commands to use= psql > as system user. Also add troubleshooting tip when service fails to start > because of incompatible cluster. > --- > doc/guix.texi | 18 ++++++++++++++++++ > 1 file changed, 18 insertions(+) > > diff --git a/doc/guix.texi b/doc/guix.texi > index 15e077a41c..1326be69e5 100644 > --- a/doc/guix.texi > +++ b/doc/guix.texi > @@ -16787,6 +16787,24 @@ The PostgreSQL daemon loads its runtime configur= ation from @var{config-file}, > creates a database cluster with @var{locale} as the default > locale, stored in @var{data-directory}. It then listens on @var{port}. >=20=20 > +If the services fails to start, it may be due to an incompatible > +cluster already present in @var{data-directory}. Adjust it (or, if you > +don't need the cluster anymore, delete @var{data-directory}), then > +restart the service. OK, deleting data-directory probably will work for every issue, e.g. data corruption for files inside :-). 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 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? > +Peer authentication is used by default and the @code{postgres} user > +account has no shell, which prevents the direct execution of @code{psql} > +commands as this user. To use @code{psql}, you can temporarily log in > +as @code{postgres} using a shell, create a PostgreSQL superuser with the > +same name as one of the system users and then create the associated > +database. > + > +@example > +sudo su postgres -s /bin/sh > +createuser --interface > +createdb $MY_USER_LOGIN # Replace appropriately. > +@end example I tried =E2=80=98sudo su postgres -s /bin/sh=E2=80=99, then: =2D-8<---------------cut here---------------start------------->8--- sh-5.0$ createuser --interface sh: createuser: command not found =2D-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 =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. To fix this we could make =E2=80=98postgres=E2=80=99 available by default a= s in https://git.savannah.gnu.org/cgit/guix.git/commit/?id=3Ddb65d7447c3adc46e2b= 24abfc07ae10c6c537df4 WDYT? Regards, Oleg. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEcjhxI46s62NFSFhXFn+OpQAa+pwFAl8cg9AACgkQFn+OpQAa +pw6Qw/9FQaG1UHYN4XyX53+sl1ZHCRDdMDllwlN6kX+Av73i4QTlhUDmQTC7udz n3qQt4otffAQg6BbnKm3gcklQo/nKjNwLlD9kcqBohjEN4nuaML2etEWURCX/Fli iib7WHmcu5AO9/f5hlJk8njUY5Sv/t7zNYTAc2OECNJUOknHNjXXHKZafotA6uS1 RWdfN33XWLr4zITb508zRMkD6Q2RZT2II42rIoCWib9Mxk7IfLBvg9LiyT7H80Fu +xXW0SBJHLpdLXsw0Z3W2EYrByANFuGJZh/rWBbJY3pyGt7XrnZBy2inmqDPSqnt fFhlU7kUL0UMikb9YS8JCT5w6vilECGMCziaFUYrEcaLg7AVd48tzi7prlS1UK17 QOAfAb/l3eeDg7iDWLSC54j0wgwSNzZLJ9wkVQisQr+1zTYQg/ORPcA/jXrrd/BO LCw428KW4gtxooRn+FEzpi6k5f5UeALhdthrWowarMgSwl9pLn/Lod3MQ1NZ40Es 9KHFMf24P9B6c6Og90JCCW6efEcl5LqiIbd3idXzguI7pJ8Qpqp53FZVNIYLz934 siW6+RRM1VPslUo8F7/HtvYo2veVxOCuAgZPktALl5/9RuMP4JZI8NJflytL2eam 0kHKplw9oH2GwI7/AMJAlE0AWpCw5pQXejodllt9TIB6WBWfdt8= =yh+P -----END PGP SIGNATURE----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Sun Jul 26 06:19:02 2020 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 To: Oleg Pykhalov Subject: Re: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. 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-Debbugs-Envelope-To: 41786 Cc: 41786@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.2 (/) --=-=-= 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----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Sun Jul 26 07:26:33 2020 Received: (at 41786) by debbugs.gnu.org; 26 Jul 2020 11:26:33 +0000 Received: from localhost ([127.0.0.1]:51866 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jzenZ-0001ND-3v for submit@debbugs.gnu.org; Sun, 26 Jul 2020 07:26:33 -0400 Received: from mail-lf1-f65.google.com ([209.85.167.65]:39667) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jzenU-0001Mw-Hu for 41786@debbugs.gnu.org; Sun, 26 Jul 2020 07:26:32 -0400 Received: by mail-lf1-f65.google.com with SMTP id v15so2942522lfg.6 for <41786@debbugs.gnu.org>; Sun, 26 Jul 2020 04:26:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=aIgYyNmKYhsb1IAV4Y3aP9olhvStbtNw5s5cPEIsZl4=; b=Yan+Ln1/3aob2d7vnPxGcjR1C38MiKzxV9E2E3i5bGgRsrIYmSYFE5ZQeAU7yzDF26 wYquFe4Tw98RfCRgpQTUcu2cgwzM8MAWoP6PnawigzTihryS5sxZzqEuJYMgtw2YETy2 PcvMKA7WpI1SbFN1jyfyDL1evXutni34iWkZMy3e9FU89Hwq8zlQ7xPSmENbWGebefCw 2tMm17O57lAmMre4v0IWJ8eN/+ErmEPVrPGTnEgsiC+KPGlvG+1mp1IXJ3//8CKBeBPk 3bL7oV8EiZ6F2V3a77AGPNaPBLh0weuEWb0UIMm+GJOk1yqJobp4Iq7eN2SJhE4q5CTH bqfQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=aIgYyNmKYhsb1IAV4Y3aP9olhvStbtNw5s5cPEIsZl4=; b=FB4I+imrxjgbANT5gCpKoGnku4EI6KBW7mVl46XyTgUPPh1ABUCeGhIySJqYxXaRZ9 5AZzVhHODzIXiOT3fL8oqwh5XWgLmPeByVmlOg0fUdSwhPrKfgHADAcFKsII82kMjAEu 8JsCtPTMKUNOXij5t6+nbsIhbz2+aG2Aat6DAreytouxt9wvxOtCgeZg4hSCvDFwuHfb iytOBQSrc7a2eN87epfZflBo2IL3TMGJLw3/p/VGUgk5R14oVznjHlU0l/yPn4k3pNM/ YUT1q9Pe7P+jz8J1bCJLOWXCcSCXdULQGq4AFbWpySbDndeLZ23KRulyvi0ZzotJR7mp 2cOw== X-Gm-Message-State: AOAM5320d6X7pIqayAU0Fw8GIzYSovKtZzmLJA2rByTZZNPncqpJ3gk9 hOxHKbn+22znLzCNPbGnvmO1ZLNV X-Google-Smtp-Source: ABdhPJz/sKEW592seVJzo22CyXOzNJ5QTuh/JDIRUX8OqWn4TQZFYjH4njtqDReDVMxMb8kF9D52qA== X-Received: by 2002:a19:4c57:: with SMTP id z84mr9513867lfa.92.1595762781747; Sun, 26 Jul 2020 04:26:21 -0700 (PDT) Received: from guixsd (ppp91-122-98-213.pppoe.avangarddsl.ru. [91.122.98.213]) by smtp.gmail.com with ESMTPSA id h26sm2277181lfj.20.2020.07.26.04.26.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 26 Jul 2020 04:26:20 -0700 (PDT) From: Oleg Pykhalov To: Pierre Neidhardt Subject: Re: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. References: <20200610093147.24347-1-mail@ambrevar.xyz> <87blk3l8a7.fsf@gmail.com> <878sf6mvea.fsf@ambrevar.xyz> Date: Sun, 26 Jul 2020 14:26:17 +0300 In-Reply-To: <878sf6mvea.fsf@ambrevar.xyz> (Pierre Neidhardt's message of "Sun, 26 Jul 2020 12:18:53 +0200") Message-ID: <87tuxujz52.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 41786 Cc: 41786@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Pierre Neidhardt writes: [=E2=80=A6] >> =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 defaul= t as in >> https://git.savannah.gnu.org/cgit/guix.git/commit/?id=3Ddb65d7447c3adc46= e2b24abfc07ae10c6c537df4 > > 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? I see only one reason not to polluting - we probably would like to =E2=80=98maintain=E2=80=99 this decision by not removing postgresql package= from all user profiles later :-). On the other hand: =2D You have a running process because of service and postgresql client technically available to everyone via /gnu/store/=E2=80=A6postgresql=E2= =80=A6/bin =2D Adding postgresql to /run/current-system/profile/bin shouldn't break anyone. =2D postgresql is useless without first time configuration by becoming a =E2=80=98postgres=E2=80=99 user to create databases and users. If you don't like polluting, then please expand the documentation about finding correct postgres client. Personally I do this by =E2=80=98pgrep -fa postgres=E2=80=99 as my user before becoming =E2=80=98postgres=E2=80=99 use= r, then copy the =E2=80=98/gnu/store/=E2=80=A6-postgresql-10.13/bin/postgres=E2=80=99 to run= =E2=80=98psql=E2=80=99 after =E2=80=98sudo=E2=80=99. Thanks, Oleg. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEcjhxI46s62NFSFhXFn+OpQAa+pwFAl8daFkACgkQFn+OpQAa +pz91Q/8DjHDGF7h5oMLMDCW3fJNWtA4siOHY4Dcf9PcL01Ub6osSa6Wzh3ANyim M4wehxNQY2dExfTiA5UgmOBImp8Eb6oJ94tPLjzufXoxc/+SOwwpy/u38k2ldvhc Bq4PU7a8SSRvglQJuRrK0jw5GAvE3Y+5xivM4H1rmZAhaRgs7eMClU3P6PgU0CqL wghxdDzomr8eoYsD9L5mtzEWqfLjVeIXngmAjV3N2HT5PDTy7g/PhybvxVRgVMSJ +akfd4J8wC9r5VAoaRnQayQump+zRQ3nWt7cD2GqSG9MKEw39MR9VYu289VRBQjY syziMWpKXqm/40FXQN/8wWu/WHrKDPPCGq/sEeE9skMfkb+0wUP4c4nPaxMk8/BG gl9NZ92pu+mMGOr/LaBFYYzHLgSMYd734bPQRqk3yyLsmxiUMI0MxwoLKHt5G6WI 1Ii/gfR9JND7NL0bIcLZ23Z8za3BqR/ClOzkVw5rSq0JSbFDwD2Y1bft+PGR/aRf vYO33+g/2vXN2JatJIWoDSSHisIlzyzQ5qv+cZCf2/THbO05LxBVJCk0RrF//lgd D7SyGKlCi5l5mqeJO26naKxCcqA1Fs6CGOQvl5tXzFg2iPc3Te1q9vhv+1v7CNtK dYC3kL9HJ63OkB89YA+O/JY8KEBxznFgaPyZpSub66YvZWeHN1A= =cuod -----END PGP SIGNATURE----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Tue Jul 28 07:59:03 2020 Received: (at 41786) by debbugs.gnu.org; 28 Jul 2020 11:59:03 +0000 Received: from localhost ([127.0.0.1]:57482 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0OG7-0002Ct-5i for submit@debbugs.gnu.org; Tue, 28 Jul 2020 07:59:03 -0400 Received: from relay8-d.mail.gandi.net ([217.70.183.201]:57743) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0OG5-0002CH-H4 for 41786@debbugs.gnu.org; Tue, 28 Jul 2020 07:59:02 -0400 X-Originating-IP: 86.246.37.13 Received: from localhost.localdomain (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 211F51BF204 for <41786@debbugs.gnu.org>; Tue, 28 Jul 2020 11:58:53 +0000 (UTC) From: Pierre Neidhardt To: 41786@debbugs.gnu.org Subject: [PATCH 1/2] services: postgresql: Provide postgresql commands. Date: Tue, 28 Jul 2020 13:58:35 +0200 Message-Id: <20200728115836.23440-1-mail@ambrevar.xyz> X-Mailer: git-send-email 2.27.0 In-Reply-To: <87tuxujz52.fsf@gmail.com> References: <87tuxujz52.fsf@gmail.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Spam-Score: -0.2 (/) X-Debbugs-Envelope-To: 41786 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.2 (-) * gnu/services/databases.scm (postgresql-service-type): Extend profile-service-type to provide postgresql commands. --- gnu/services/databases.scm | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/gnu/services/databases.scm b/gnu/services/databases.scm index 473ece4e97..2bddf70f71 100644 --- a/gnu/services/databases.scm +++ b/gnu/services/databases.scm @@ -276,7 +276,9 @@ host all all ::1/128 md5")) (service-extension activation-service-type postgresql-activation) (service-extension account-service-type - (const %postgresql-accounts)))) + (const %postgresql-accounts)) + (service-extension profile-service-type + (compose list postgresql-configuration-postgresql)))) (default-value (postgresql-configuration)))) (define* (postgresql-service #:key (postgresql postgresql) base-commit: 64e8f2ec2dc6301019a5b93a82787ea6adaf8c76 -- 2.27.0 From debbugs-submit-bounces@debbugs.gnu.org Tue Jul 28 07:59:03 2020 Received: (at 41786) by debbugs.gnu.org; 28 Jul 2020 11:59:03 +0000 Received: from localhost ([127.0.0.1]:57484 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0OG7-0002Cv-Eq for submit@debbugs.gnu.org; Tue, 28 Jul 2020 07:59:03 -0400 Received: from relay8-d.mail.gandi.net ([217.70.183.201]:48267) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0OG5-0002CJ-Jf for 41786@debbugs.gnu.org; Tue, 28 Jul 2020 07:59:02 -0400 X-Originating-IP: 86.246.37.13 Received: from localhost.localdomain (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 5A6A11BF209 for <41786@debbugs.gnu.org>; Tue, 28 Jul 2020 11:58:55 +0000 (UTC) From: Pierre Neidhardt To: 41786@debbugs.gnu.org Subject: [PATCH 2/2] doc: Explain how to use psql with peer authentication. Date: Tue, 28 Jul 2020 13:58:36 +0200 Message-Id: <20200728115836.23440-2-mail@ambrevar.xyz> X-Mailer: git-send-email 2.27.0 In-Reply-To: <20200728115836.23440-1-mail@ambrevar.xyz> References: <87tuxujz52.fsf@gmail.com> <20200728115836.23440-1-mail@ambrevar.xyz> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Spam-Score: -0.2 (/) X-Debbugs-Envelope-To: 41786 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.2 (-) * doc/guix.texi (Database Services): Add example of shell commands to use psql as system user. Also add troubleshooting tip when service fails to start because of incompatible cluster. --- doc/guix.texi | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/doc/guix.texi b/doc/guix.texi index 74c7417174..aba3f925b9 100644 --- a/doc/guix.texi +++ b/doc/guix.texi @@ -17260,6 +17260,24 @@ The PostgreSQL daemon loads its runtime configuration from @var{config-file}, creates a database cluster with @var{locale} as the default locale, stored in @var{data-directory}. It then listens on @var{port}. +If the services fails to start, it may be due to an incompatible +cluster already present in @var{data-directory}. Adjust it (or, if you +don't need the cluster anymore, delete @var{data-directory}), then +restart the service. + +Peer authentication is used by default and the @code{postgres} user +account has no shell, which prevents the direct execution of @code{psql} +commands as this user. To use @code{psql}, you can temporarily log in +as @code{postgres} using a shell, create a PostgreSQL superuser with the +same name as one of the system users and then create the associated +database. + +@example +sudo -u postgres -s /bin/sh +createuser --interface +createdb $MY_USER_LOGIN # Replace appropriately. +@end example + @cindex postgresql extension-packages Additional extensions are loaded from packages listed in @var{extension-packages}. Extensions are available at runtime. For instance, -- 2.27.0 From debbugs-submit-bounces@debbugs.gnu.org Tue Jul 28 07:59:57 2020 Received: (at 41786) by debbugs.gnu.org; 28 Jul 2020 11:59:57 +0000 Received: from localhost ([127.0.0.1]:57487 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0OGy-0002EB-Oq for submit@debbugs.gnu.org; Tue, 28 Jul 2020 07:59:57 -0400 Received: from relay5-d.mail.gandi.net ([217.70.183.197]:35063) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0OGw-0002Dy-Ka for 41786@debbugs.gnu.org; Tue, 28 Jul 2020 07:59:55 -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 relay5-d.mail.gandi.net (Postfix) with ESMTPSA id 77EC41C000A; Tue, 28 Jul 2020 11:59:48 +0000 (UTC) From: Pierre Neidhardt To: Oleg Pykhalov Subject: Re: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. In-Reply-To: <87tuxujz52.fsf@gmail.com> References: <20200610093147.24347-1-mail@ambrevar.xyz> <87blk3l8a7.fsf@gmail.com> <878sf6mvea.fsf@ambrevar.xyz> <87tuxujz52.fsf@gmail.com> Date: Tue, 28 Jul 2020 13:59:47 +0200 Message-ID: <87wo2ndf4c.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-Debbugs-Envelope-To: 41786 Cc: 41786@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.2 (/) --=-=-= Content-Type: text/plain Content-Transfer-Encoding: quoted-printable I've just sent an update which includes the postgresql commands in the service and changes the sudo command. Let me know if you are satisfied with these changes or if you think the doc paragraph could still be improved. Cheers! =2D-=20 Pierre Neidhardt https://ambrevar.xyz/ --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEUPM+LlsMPZAEJKvom9z0l6S7zH8FAl8gEzMACgkQm9z0l6S7 zH8X+Qf/f7ZXgiDvupWfpHIv0sSh95v4ufBHV+x/HS/LwAMm28K6HFQdi5EsWSOq OcOayKrPdoN4aaPtyurHYua8fuOsHGZWvgkIqAqDZcI31+RHjfrAHj+P9vv4v3jA NqmqA4Il/CvmmY3pO3WKoe1FL+PHaWp4cylPxG8gTRE19Ol4nQLKuWF0yv2EjQEk QqmWji+t77WVw41idd8F7qcqldXwnrVY6LhRYkc5dW2BTKHEtaUSbNRgQ6vuRG8+ P6WIvJ0SM1N+gdmb9KRSRmgGVBFYbmNFPqYfG9mtO+hCaKw+qB/T33oGObxAGx+6 OlI8D0FsJSwc5Lh41yqjN/DBPheXcw== =NQi4 -----END PGP SIGNATURE----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Tue Jul 28 14:03:07 2020 Received: (at 41786) by debbugs.gnu.org; 28 Jul 2020 18:03:07 +0000 Received: from localhost ([127.0.0.1]:59096 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0TwR-0007H5-Aq for submit@debbugs.gnu.org; Tue, 28 Jul 2020 14:03:07 -0400 Received: from mail-lj1-f195.google.com ([209.85.208.195]:43520) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k0TwO-0007GW-Vb for 41786@debbugs.gnu.org; Tue, 28 Jul 2020 14:03:05 -0400 Received: by mail-lj1-f195.google.com with SMTP id f5so22138531ljj.10 for <41786@debbugs.gnu.org>; Tue, 28 Jul 2020 11:03:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=lUgayroc5Z8YLPrZZZoeHy9ADOZZTt8dgSHkiMArZOM=; b=IP8J23WpQ63BT4KwPI4/le9yBTMc98XI20LhDEkXIrqaNMQoGhCnSQnJZe4fN4TKIy /5ZEeUBMp8acrWBcHCNYav9/JoSe/1/OGdKEXUsp7kXGYC+ndf4k6NvIvQoyB/E9A3rX g2al82tNcsY87+xmGPt0nnvTfwKFvayq28QUr670y2UuDjqke8/NsehL1S1TOUUyoANq licFAcP/L+MoSmU9kHigvSjURBs8B5qqfSF1VnYSL5W5+jTVbGM02qttzLENgBaBSOgr HM7OmNzGcrtL6Js0PLscMJkRM75pczjZchLb+kyUhO2ufukWPB79c8JJgEcB+h+Hs1Cu cD5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=lUgayroc5Z8YLPrZZZoeHy9ADOZZTt8dgSHkiMArZOM=; b=OTl4YN090nR7BUiU2TPTEX7B3QSAZEYT/wJyWKibPjO9Yl4/xwN1zCuMhPblxRm8HY RDl1Z0l3VkNqntu7oLUs+kU0M1zHby+3xIYl5Sdg4Dv514CXkam0j0+iPUraa8RA6f/m C/ucUb4zgKvQRTo7HJ/Z8B2+qCQjMU3Jtok7UtlZRho2kBI7C1nZAERPBVacWSisGdgU BgSVHGL9aucgnQBJEX19+QYIO0OHpnwMqBZym2dmJbQEqIOKfzIwp3z1OJDk2S3Qdj1n N5xq1HaQ+2zE5mCcusFVaXJozMqZ+7w2AeUlT537279vNeI8H02M8UbU3IMxTfDM7vx9 lCeQ== X-Gm-Message-State: AOAM531t6QTyFT0fwtcLP+f9CEn0XQL8CFvFP5crAvStm20g7Z2GkORM 6/u0URtO7KFLb5aWusjwQOXPCD1cCJ0= X-Google-Smtp-Source: ABdhPJyIaHxMM/U7NubnNa4ppPRxGDyPuTn26Dpkzis2r2fv/pf+BGYSBluGeEkCNU+09eYQNn+v4g== X-Received: by 2002:a2e:99c6:: with SMTP id l6mr14199988ljj.220.1595959378157; Tue, 28 Jul 2020 11:02:58 -0700 (PDT) Received: from guixsd (ppp91-122-98-213.pppoe.avangarddsl.ru. [91.122.98.213]) by smtp.gmail.com with ESMTPSA id w26sm1938943ljw.79.2020.07.28.11.02.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 28 Jul 2020 11:02:56 -0700 (PDT) From: Oleg Pykhalov To: Pierre Neidhardt Subject: Re: [bug#41786] [PATCH 2/2] doc: Explain how to use psql with peer authentication. References: <87tuxujz52.fsf@gmail.com> <20200728115836.23440-1-mail@ambrevar.xyz> <20200728115836.23440-2-mail@ambrevar.xyz> Date: Tue, 28 Jul 2020 21:02:53 +0300 In-Reply-To: <20200728115836.23440-2-mail@ambrevar.xyz> (Pierre Neidhardt's message of "Tue, 28 Jul 2020 13:58:36 +0200") Message-ID: <87mu3jmsaa.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 41786 Cc: 41786@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi, Pierre Neidhardt writes: [=E2=80=A6] > +@example > +sudo -u postgres -s /bin/sh > +createuser --interface ^^^^^^^^^ Rather =E2=80=9Cinteractive=E2=80=9D. Otherwise LGTH. Thanks, Oleg. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEcjhxI46s62NFSFhXFn+OpQAa+pwFAl8gaE0ACgkQFn+OpQAa +pw9qA/+NE5vILYkSQ2lnOqU5gIvDOa99icqOGUODY7Kva+qSSCAoIRuP8RwmZep pkDsqq0pGrwev9Y9LdYx2LWkN7GCBXwB1gAwMBADz8OyEAkm/VXioRQGuamqR3Yj BzyHlpNFH6x1GHnbQ86m8Qc37BzfDYO2Bh/lna1wJnIEOOusg31RQk5WC8c1k+8G 3NQaG7cLIiSww3odslmGCEbE44Di0726Myq+A3lxd+P6qPn8lDQAeOzm5iaMNxbY sTceYLAc6KjnmsiGo4HxsHfuIxCDR2cDrV8rVGQWtzcybG7CZT0241bvW4OEwAeC PXyhKmWntlXw3h67i9SkZfw32SMY5tOOJKNgJcUoR4FqI/JL9tBs1NMnzxGobhrj kepiMuNYAEvORXUkUm+M5HgRasaWBOpWC0fvxk72Av9GK1uykWFGlxWEfcw8x8U8 ow5e4xvczS/C9NE8fcDczPqc/i8OXDlW0rhTG1aaFXYz4Srxu7PIPHQBcjzxdnG7 7qv29xkpEa35+AStksq3Fg+wtiBvPMq+IIAlsOB6FS0eSOG8db4v3pR4srrTeypB VES4LwUqWOe7FBkxVUJg5lk2b30q5WpXWZfa9/Xfchw4KCsNihoDa+sYm8LIqdf8 vmt/Iud1eQ2I/1HayDt8aYeDkNDxpeqEMJSjz/Ue9vS/MdSJYIs= =s1IK -----END PGP SIGNATURE----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Sat Aug 01 06:03:58 2020 Received: (at 41786) by debbugs.gnu.org; 1 Aug 2020 10:03:58 +0000 Received: from localhost ([127.0.0.1]:39178 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k1oMw-0000Pa-DY for submit@debbugs.gnu.org; Sat, 01 Aug 2020 06:03:58 -0400 Received: from relay8-d.mail.gandi.net ([217.70.183.201]:54269) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k1oMu-0000PD-2H for 41786@debbugs.gnu.org; Sat, 01 Aug 2020 06:03:57 -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 2FA541BF207; Sat, 1 Aug 2020 10:03:48 +0000 (UTC) From: Pierre Neidhardt To: Oleg Pykhalov Subject: Re: [bug#41786] [PATCH 2/2] doc: Explain how to use psql with peer authentication. In-Reply-To: <87mu3jmsaa.fsf@gmail.com> References: <87tuxujz52.fsf@gmail.com> <20200728115836.23440-1-mail@ambrevar.xyz> <20200728115836.23440-2-mail@ambrevar.xyz> <87mu3jmsaa.fsf@gmail.com> Date: Sat, 01 Aug 2020 12:03:48 +0200 Message-ID: <87ime2adiz.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-Debbugs-Envelope-To: 41786 Cc: 41786@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.2 (/) --=-=-= Content-Type: text/plain Merged in 1f0a41e95505c12af17c416651d70f18ea7c6a07, thanks! --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEUPM+LlsMPZAEJKvom9z0l6S7zH8FAl8lPgQACgkQm9z0l6S7 zH+bigf/SYhGkmfGK8FHWVKo/uMbMmpbZ2NROpqbqhIvbQy8PD8mu0TEge8xRwu+ YbTNXRhBFlSVyaIBx012dkZuCJ16ZxSO/3EoWZDBdlMPABRZHd4adSXojMPEBg6B RhXSFxJMDFMFHpzF0spHSJhupEjmyZM1E0zIkM38I87D93cOvT5thq387yOTYiDp cQXRezdrmWskfRCa5UrJzhKSYNcLfWmeDv5cJNxW791yS04Jv5tg9Dh8duTiN7HJ Ud1uWh0/Ukssjbi2vihbDRFMBAQqlUEkHkd/HkcrNTR/05OY8FJP5dSXT6J+D/Vp LSXm7pxP8dQAvMrA20XoL4i0CoAGzw== =C1vY -----END PGP SIGNATURE----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Sat Aug 01 06:04:14 2020 Received: (at control) by debbugs.gnu.org; 1 Aug 2020 10:04:14 +0000 Received: from localhost ([127.0.0.1]:39182 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k1oNC-0000Qm-JR for submit@debbugs.gnu.org; Sat, 01 Aug 2020 06:04:14 -0400 Received: from relay1-d.mail.gandi.net ([217.70.183.193]:52717) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k1oNB-0000QT-8x for control@debbugs.gnu.org; Sat, 01 Aug 2020 06:04:13 -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 relay1-d.mail.gandi.net (Postfix) with ESMTPSA id 0CD8E240003 for ; Sat, 1 Aug 2020 10:04:06 +0000 (UTC) Date: Sat, 01 Aug 2020 12:04:06 +0200 Message-Id: <87h7tmadih.fsf@ambrevar.xyz> To: control@debbugs.gnu.org From: Pierre Neidhardt Subject: control message for bug #41786 X-Spam-Score: 1.8 (+) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: close 41786 quit Content analysis details: (1.8 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -0.7 RCVD_IN_DNSWL_LOW RBL: Sender listed at https://www.dnswl.org/, low trust [217.70.183.193 listed in list.dnswl.org] 0.0 RCVD_IN_MSPIKE_H3 RBL: Good reputation (+3) [217.70.183.193 listed in wl.mailspike.net] -0.0 SPF_PASS SPF: sender matches SPF record 0.0 SPF_HELO_NONE SPF: HELO does not publish an SPF Record 0.5 FROM_SUSPICIOUS_NTLD From abused NTLD 2.0 FROM_SUSPICIOUS_NTLD_FP From abused NTLD 0.0 RCVD_IN_MSPIKE_WL Mailspike good senders X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.2 (-) close 41786 quit From unknown Fri Jun 20 07:24:16 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Sat, 29 Aug 2020 11:24:08 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator