From: | uğur Karabin <ugurkarabin(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "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:39:32 |
Message-ID: | CAJbddZQEFn7SmQH8aYOqy-YkY+kbf8MrObVy+7NAB-tEKGW8Mw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)albe(at)wien(dot)gv(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-05-03 13:18:37 | Re: Function PostgreSQL 9.2 |
Previous Message | Nicolas Paris | 2016-05-03 12:21:40 | postgresql & Fulltext & ranking & my own functions |