Re: Connection problem (newbie question)

HI Paul: you would need to specify a database name such as the
"template1". The "template1" database is installed by default as you
install PostgreSQL.

psql <database name>

If you do not specify a database name, the default database name that
psql will use is 'postgresql"

Regards
TaChung Huang (黃大忠)

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Paul Kavanagh
Sent: Saturday, December 07, 2002 12:51 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Connection problem (newbie question)

Hi,

I've just installed Postgresql 7.3 via Cygwin on Win2K, started the
postmaster successfully, yet cannot connect using psql. See below for
trace:

$ pg_ctl start -D /usr/share/postresql/data -l serverlog postmaster
successfully started

$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

I've attached my .conf.

Any ideas ?

Thanks in advance,
-Paul