Date: Wed, 10 Jul 2013 19:06:23 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: "Struckhoff, Kevin" <kstruckhoff@ebay.com>
Cc: Kevin Grittner <kgrittn@ymail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Connecting to a remote db server
Message-ID: <20130710230623.GI4941@eldon.alvh.no-ip.org>
References: 
 <9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com>
 <1373495077.98876.YahooMailNeo@web162906.mail.bf1.yahoo.com>
 <9EDDE77AB269C54AA685BE1F72B5CA3B08757F@DEN-EXDDA-S21.corp.ebay.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <9EDDE77AB269C54AA685BE1F72B5CA3B08757F@DEN-EXDDA-S21.corp.ebay.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin