From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | 'dandl *EXTERN*' <david(at)andl(dot)org>, 'Postgres General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Does the initial postgres user have a password? |
Date: | 2016-05-03 12:03:57 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B5384A027@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
dandl wrote:
> I have a new 9.5 installation, Windows x64, developer only. No users have been added, and no passwords
> set.
>
> I can access the system:
> · using pgAdmin3, without specifying a user or password
> · using psql, specifying user ‘postgres’ but no password
>
> I cannot access the system with various other tools that require a connection string eg
> password authentication failed for user "postgres"
>
> There is a ‘postgres’ user defined in pg_shadow with password of :
> "md5a19959576d12fc69375fc3dadaeab90b"
>
> What is going on here? Is there a password for user ‘postgres’ or isn’t there? What is it? Why don’t I
> need it sometimes, and I do other times?
You have a password set, and it is probably in a password file, which
might have been created by pgAdmin III.
See http://www.postgresql.org/docs/current/static/libpq-pgpass.html
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Paris | 2016-05-03 12:21:40 | postgresql & Fulltext & ranking & my own functions |
Previous Message | Mike Sofen | 2016-05-03 11:53:45 | Re: (VERY) Slow Query - PostgreSQL 9.2 |