You might want to check that you have run initdb. Log in as user postgres and type: /usr/local/pgsql/bin/initdb Then check to make sure that postmaster is actually running, as someone else suggested. At 11:21 PM 1/15/00, C.D. Gan wrote: >I'm just trying to run PGSQL and running the test for it. However I get >this message, > >Connection to database 'template1' failed. >connectDB() -- connect() failed: No such file or directory >Is the postmaster running at 'localhost' and accepting connections on Unix >socket '5432'? > >createdb: database creation failed on i-city. > >What does that mean? Is it mean that the connect() file is not found under >my /usr/local/pgsql/bin? > >Gan >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > > >************ > ************