[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[bug#41786] [PATCH] doc: Explain how to use psql with peer authenticatio
From: |
Oleg Pykhalov |
Subject: |
[bug#41786] [PATCH] doc: Explain how to use psql with peer authentication. |
Date: |
Sun, 26 Jul 2020 14:26:17 +0300 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) |
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.
signature.asc
Description: PGP signature