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 KJnqMI1oHV+LOwAA0tVLHw (envelope-from ) for ; Sun, 26 Jul 2020 11:27:09 +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 mBjILI1oHV+ESgAAB5/wlQ (envelope-from ) for ; Sun, 26 Jul 2020 11:27:09 +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 07232940415 for ; Sun, 26 Jul 2020 11:27:08 +0000 (UTC) Received: from localhost ([::1]:54560 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jzeo6-0000xx-BL for larch@yhetil.org; Sun, 26 Jul 2020 07:27:06 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:48664) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jzeo2-0000wB-Dh for guix-patches@gnu.org; Sun, 26 Jul 2020 07:27:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:40320) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jzeo2-0007ph-4C for guix-patches@gnu.org; Sun, 26 Jul 2020 07:27:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1jzeo1-0001Nw-W7 for guix-patches@gnu.org; Sun, 26 Jul 2020 07:27:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. Resent-From: Oleg Pykhalov Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Sun, 26 Jul 2020 11:27:01 +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: Pierre Neidhardt Cc: 41786@debbugs.gnu.org Received: via spool by 41786-submit@debbugs.gnu.org id=B41786.15957627935287 (code B ref 41786); Sun, 26 Jul 2020 11:27:01 +0000 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 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-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -1.0 (-) 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=fail (rsa verify failed) header.d=gmail.com header.s=20161025 header.b=Yan+Ln1/; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=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: -2.01 X-TUID: ST4nR4ypGVCj --=-=-= 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----- --=-=-=--