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:[EMAIL PROTECTED]]
> Sent: Saturday, December 07, 2002 1:48 PM
> To: 'Paul Kavanagh'; [EMAIL PROTECTED]
> 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 (¶À¤j©¾)
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Paul Kavanagh
> Sent: Saturday, December 07, 2002 12:51 PM
> To: [EMAIL PROTECTED]
> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
