Re: Server starts, but I can't connect

On 6 July 2011 02:38, Boyd, Craig <craig(at)mysoftforge(dot)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