From: Oleg Pykhalov <go.wigust@gmail.com>
To: Pierre Neidhardt <mail@ambrevar.xyz>
Cc: 41786@debbugs.gnu.org
Subject: [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication.
Date: Sun, 26 Jul 2020 14:26:17 +0300 [thread overview]
Message-ID: <87tuxujz52.fsf@gmail.com> (raw)
In-Reply-To: <878sf6mvea.fsf@ambrevar.xyz> (Pierre Neidhardt's message of "Sun, 26 Jul 2020 12:18:53 +0200")
[-- Attachment #1: Type: text/plain, Size: 1537 bytes --]
Pierre Neidhardt <mail@ambrevar.xyz> writes:
[…]
>> ‘createuser’ and ‘createdb’ are in ‘/gnu/store/…-postgresql-10.13/bin’,
>> which is missing in my ‘postgres’ user's profile.
>
> Right, I have postgresql installed in my user profile.
>
>> To fix this we could make ‘postgres’ available by default as in
>> https://git.savannah.gnu.org/cgit/guix.git/commit/?id=db65d7447c3adc46e2b24abfc07ae10c6c537df4
>
> 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
‘maintain’ this decision by not removing postgresql package from all
user profiles later :-).
On the other hand:
- You have a running process because of service and postgresql client
technically available to everyone via /gnu/store/…postgresql…/bin
- Adding postgresql to /run/current-system/profile/bin shouldn't break
anyone.
- postgresql is useless without first time configuration by becoming a
‘postgres’ 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 ‘pgrep -fa
postgres’ as my user before becoming ‘postgres’ user, then copy the
‘/gnu/store/…-postgresql-10.13/bin/postgres’ to run ‘psql’ after ‘sudo’.
Thanks,
Oleg.
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 832 bytes --]
next prev parent reply other threads:[~2020-07-26 11:27 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2020-06-10 9:31 [bug#41786] [PATCH] doc: Explain how to use psql with peer authentication Pierre Neidhardt
2020-07-25 19:11 ` Oleg Pykhalov
2020-07-26 10:18 ` Pierre Neidhardt
2020-07-26 11:26 ` Oleg Pykhalov [this message]
2020-07-28 11:58 ` [bug#41786] [PATCH 1/2] services: postgresql: Provide postgresql commands Pierre Neidhardt
2020-07-28 11:58 ` [bug#41786] [PATCH 2/2] doc: Explain how to use psql with peer authentication Pierre Neidhardt
2020-07-28 18:02 ` Oleg Pykhalov
2020-08-01 10:03 ` Pierre Neidhardt
2020-07-28 11:59 ` [bug#41786] [PATCH] " Pierre Neidhardt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://guix.gnu.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87tuxujz52.fsf@gmail.com \
--to=go.wigust@gmail.com \
--cc=41786@debbugs.gnu.org \
--cc=mail@ambrevar.xyz \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/guix.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).