You don't give many details. I'll assume you're using some variant of
Unix.
[1] Have you checked that the postmaster is running? Try running 'ps
aux' to check that it is.
[2] Have services been enabled for port 5432? Check /etc/services.
I have a pair of lines:
postgres 5432/tcp # POSTGRES
postgres 5432/udp # POSTGRES
[3] Do you have permissions to the given database?
[4] When all else fails, you can try running strace on the process.
(Please read the strace man page).
Hope this helps!
-frank
On Sun, 16 Jan 2000, 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
>
>
> ************
>
>