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