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

From Thom Brown
Subject Re: Server starts, but I can't connect
Date
Msg-id CAA-aLv7Cq5hcXAJGSDeomM+f6akEOzndqv3+RzoOVxExELjX6g@mail.gmail.com
Whole thread Raw
In response to Server starts, but I can't connect  ("Boyd, Craig" <craig@mysoftforge.com>)
List pgsql-novice
On 6 July 2011 02:38, Boyd, Craig <craig@mysoftforge.com> wrote:
> 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.

Did you get PostgreSQL to reload the config? "sudo service postgresql reload"

This would tell it to re-read your pg_hba.conf file.

Also note that the order of rows in pg_hba.conf is important too as it
will use the first line that matches login details.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-novice by date:

Previous
From: "Boyd, Craig"
Date:
Subject: Server starts, but I can't connect
Next
From: Michael Wood
Date:
Subject: Re: Server starts, but I can't connect