[rt-users] initialize-database error - Postgresql on FC1

[Phil Lawrence]

Phil Lawrence wrote:
> Fedora Core 1
> Postgresql 7.3.4

> # # make initialize-database
> ...
> Password: DBI connect('dbname=template1;host=localhost','postgres',...) 
> failed: could not connect to server: ...

Tom Good (http://www.sqlclinic.net) provided the answer.  pg_hba.conf as 
shipped by FC1 doesn't allow linux users to login to pg using any 
username other than their own, linux user name.  So in this case, root 
is attempting to login as postgres.

Here's the change:
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   trust


Phil