Postgres Pro
Downloads
Home   >   mailing lists

Re: psql -U postgres does not require a password - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: psql -U postgres does not require a password
Date
Msg-id Pine.LNX.4.21.0011061701100.776-100000@peter.localdomain
Whole thread Raw
In response to psql -U postgres does not require a password  (Silvan Calarco <silvan@goemon.polito.it>)
List pgsql-admin
Tree view 
Silvan Calarco writes:

> psql database_name -U postgres
>
> I'm not asked for a password and every user can access the database with
> postgres privileges.

psql only asks for a password if the server requires password
authentication.  Look into pg_hba.conf how to set that up.  (Might be in
/var/lib/pgsql/... on your system.)

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

pgsql-admin by date:

Previous
From: "Dr. Hans-Christian Waldmann"
Date:
Subject: Re: psql -U postgres does not require a password
Next
From: Lamar Owen
Date:
Subject: Re: psql -U postgres does not require a password