Skip site navigation (1) Skip section navigation (2)

Re: can't connect with md5 encrypted pw

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Schuster <thom(dot)schuster(at)gmx(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: can't connect with md5 encrypted pw
Date: 2008-02-11 17:14:59
Message-ID: 3305.1202750099@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Thomas Schuster <thom(dot)schuster(at)gmx(dot)de> writes:
> my problem:
> createdb test
> psql -U john -d test -W
> password:******
> psql: FATAL:  password authentication failed for user "john"

Given the facts you show, the most obvious explanation is that you
entered the wrong password.  You might want to do an ALTER USER PASSWORD
command (as the superuser) just to make sure you didn't fat-finger the
password setting initially.

If that isn't it, try looking into the postmaster log to see if it logs
any additional details about the failure.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Tena SakaiDate: 2008-02-11 18:53:25
Subject: 8.3.0 upgrade, confused by documentation
Previous:From: Scott CottonDate: 2008-02-11 16:46:49
Subject: Re: can't revoke users

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group