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

Phil Lawrence prlawrence at Lehigh.EDU
Tue May 18 16:33:06 EDT 2004


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



More information about the rt-users mailing list