Re: postgresql db account - Mailing list pgsql-novice

From Tom Lane
Subject Re: postgresql db account
Date
Msg-id 12626.1160056910@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgresql db account  (Ray Stell <stellr@cns.vt.edu>)
Responses Re: postgresql db account  (Darren R <darrenr114@yahoo.com>)
List pgsql-novice
Ray Stell <stellr@cns.vt.edu> writes:
> Thanks, again, someone said there was no pw on the account, but if I
> set local md5 I am prompted for a pw.  Enter doesn't let you in.  Is
> the default known?

Yes: there isn't one.  If you want to use pw authentication, you have to
first set a password for the superuser account, then change the auth
method.  This is why pw auth is not the initial default.

(Actually, if you do a manual initdb, you can specify a password at that
time and choose pw auth as the default auth method too.  But this
approach is discouraged by most pre-packaged installations.)

            regards, tom lane

pgsql-novice by date:

Previous
From: Ray Stell
Date:
Subject: Re: pg_ctl -D?
Next
From: Ray Stell
Date:
Subject: un-initdb?