Re: Connecting to a remote db server

Thanks Alvaro, that works. Appreciate the help.

Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations

kstruckhoff(at)ebay(dot)com ebayenterprise.com
o: 818.686.4719  | c: 818.968.0634 |

The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)2ndquadrant(dot)com]
Sent: Wednesday, July 10, 2013 4:06 PM
To: Struckhoff, Kevin
Cc: Kevin Grittner; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Connecting to a remote db server

Struckhoff, Kevin wrote:
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> 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 answer of course is No..

Oh, well, you need to specify the hostname or address of the remote server:

psql -h db01 test

Otherwise, it's just trying to connect to localhost, as you've seen.

You might need to adjust pg_hba.conf on the db01 server to allow
connections from your app01 client host.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services