Other tools may try to connect with different users or with same users but using ip (not local host) and pg_hba.conf file may not allow paswordless login except localhost.Reseting postgres password with alter user, and configuring pg_hba.conf file can solve your problem.
Regards, Ugur 2016-05-03 15:03 GMT+03:00 Albe Laurenz <laurenz.a...@wien.gv.at>: > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
