Can't access superuser in postgresql

Question

I can't seem to access my superuser account for my posgresQL database.

Using the command:

psql -U postgres

I sucessfully login into the user 'postgres'. However, this is not the default superuser. Doing:

=# \du

I get:

List of roles
 Role name |             Attributes              | Member of 
-----------+-------------------------------------+-----------
pgsql     | Superuser, Create DB                | {}
postgres  | Create role, Create DB, Replication | {}

So 'pgsql' appears to be my default superuser.

When trying:

psql -U pgsql

I get the following error:

psql: FATAL:  database "pgsql" does not exist

I changed the pg_hba.conf file to the following:

# Database administrative login by Unix domain socket
local   all             all                                trust

and also tried:

# Database administrative login by Unix domain socket
local   all             pgsql                                trust

but I still get the same error regardless, that database 'pgsql' does not exist.

Any help would be greatly appreciated, I need to be able to access the database's superuser.

Vao Tsun · Accepted Answer · 2017-10-04 15:50:50Z

1

just define database:

psql -U pgsql -d postgres

if you get error that postgres database does not exist, connect as postgres and list databases with \l

answered Oct 4, 2017 at 15:50

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can't access superuser in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related