Re: Connection problem (newbie question)

Thanks TaChung, and I tried that, but unfortunately the end result was the
same:

$ psql template1
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"?

Connecting to the port via telnet fails:

$ telnet localhost 5432
Connecting To localhost...Could not open a connection to host on port 5432 :
Connect failed

I tried connecting via pgAdmin 11 (1.4) and got the following error msg:
"Number: -2147467259 Description: Could not connect to the server; Could not
connect to the remote socket"

Finally, I ran 'ps -ef' just after the postmaster successfully started (or
so it says), but there's no sign of any postgresql related processes:

$ ps -ef
UID PID PPID TTY STIME COMMAND
pkavan 1868 1 con 11:07:57 /usr/bin/bash
pkavan 1692 1868 con 21:27:06 /usr/bin/ps

I'm guessing the problems are all interconnected, but I thought the above
info might help..

Thanks in advance,
-Paul

> -----Original Message-----
> From: TaChung Huang [mailto:tachung_h(at)yahoo(dot)com]
> Sent: Saturday, December 07, 2002 1:48 PM
> To: 'Paul Kavanagh'; pgsql-admin(at)postgresql(dot)org
> Subject: RE: [ADMIN] 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