PostgreSQL - How to login with my Linux user account

From: Amn Ojee Uw <amnojeeuw(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL - How to login with my Linux user account
Date: 2023-07-28 00:19:27
Message-ID: ae4781f7-5221-0ea3-e2ed-611bd5078409@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to log into my newly installed PostgreSQL [ PostgreSQL 12.15
(Debian 12.15-1.pgdg120+1) ] using my linux account.
In trying to do that this web page
<https://alvinalexander.com/blog/post/postgresql/log-in-postgresql-database/>suggest
that I enter :

psql -d mydb -U myuser -W

However, that command requires a database_name (mydb), and PosgreSQL 12.15 being so freshly installed does not yet
have any database created by me.

How would you suggest I circumvent this challenge?

Mind you that, using the postgres account I have created other accounts.

Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
chispa | Superuser | {}
pedro | Superuser | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

Thanks in advance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-07-28 00:23:13 Re: PostgreSQL - How to login with my Linux user account
Previous Message Adrian Klaver 2023-07-27 21:45:48 Re: password error in batch script