From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | "Markova, Nina" <nmarkova(at)NRCan(dot)gc(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: setting Postgres client |
Date: | 2008-09-19 14:41:37 |
Message-ID: | 20080919104137.5afc51ab.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Markova, Nina" <nmarkova(at)NRCan(dot)gc(dot)ca> wrote:
>
> - On the client I tried:
> psql sta
> 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"?
The client tries to connect to the unix domain socket by default (as
can be seen by the error message)
If your client system and server don't share the same /tmp filesystem,
then that is going to fail, which is expected. Either specify the
IP address/hostname you want to connect to with -h or put options in
your .psqlrc file or set appropriate environment variables. More
details here:
http://www.postgresql.org/docs/8.2/static/app-psql.html
--
Bill Moran
Collaborative Fusion Inc.
wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023
From | Date | Subject | |
---|---|---|---|
Next Message | Markova, Nina | 2008-09-19 14:49:58 | Re: setting Postgres client |
Previous Message | Scott Marlowe | 2008-09-19 14:34:07 | Re: Query planner issue |