Re: Server starts, but I can't connect - Mailing list pgsql-novice

From Tom Lane
Subject Re: Server starts, but I can't connect
Date
Msg-id 21617.1309921891@sss.pgh.pa.us
Whole thread Raw
In response to Server starts, but I can't connect  (Craigbert <postgresql@mysoftforge.com>)
Responses Re: Server starts, but I can't connect  (Craigbert <postgresql@mysoftforge.com>)
List pgsql-novice
Craigbert <postgresql@mysoftforge.com> writes:
> Hello All,
> I am running PostgreSQL 8.4 on Kubuntu 11.04.
> The server starts without any issues, but I can not connect.  I keep
> getting an invalid user/password error.
> I am connecting to the localhost, default port, user = postgres,
> database = postgres
> I have tried setting the authentication methods to trust in the
> pg_hba.conf file, but it does not make any difference.

> What am I doing wrong?

You could not get that type of error when running "trust"
authentication.  So, you aren't.  Likely theories are that you forgot to
reload or restart the server after changing pg_hba.conf, or that you did
reload but it didn't "take" because of some error in the modified hba
file (if so, there'll be some complaint about it in the server log
file), or that the file you're changing isn't the one being used by the
server you're actually connecting to.

            regards, tom lane

pgsql-novice by date:

Previous
From: Craigbert
Date:
Subject: Server starts, but I can't connect
Next
From: Craigbert
Date:
Subject: Re: Server starts, but I can't connect