Please note the following :
psql (12.15 (Debian 12.15-1.pgdg120+1
Thanks in advance
On 7/20/23 10:41 a.m., Adrian Klaver
wrote:
On 7/19/23 23:32, Alban Hertroys wrote:
On 20 Jul 2023, at 02:36, Amn Ojee Uw <amnojeeuw@xxxxxxxxx> wrote:
After this command 'sudo -u postgres psql'
I get this message :
could not change directory to "/home/my_account": Permission denied
What’s the reason that you’re using the OS user postgres?
Because the Debian/Ubuntu packaging sets up pg_hba.conf to use peer auth for local connections and the only database user created is postgres.
See:
https://ubuntu.com/server/docs/databases-postgresql
for more information.
If you’re simply trying to connect to the database named postgres as database user postgres, you can instead use the command 'psql -U postgres postgres’.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
