DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=HsmvymtmKGqDTgmDcUb50npXQrHw+n+R1oz6zTK54rUxvHQYD1T8aEvJi0z+hbIzxEXBXNcFgXLpJ97tP4rorsPAelSNpKhzL+zuIBEIjyE6qam57r1tdhlZy04TFfM83V/0ZBMNobbwrxJTVfFq+WNMJUA34xBwsYmeqU6ucis=
 ;
References: 
 <9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com>
 <1373495077.98876.YahooMailNeo@web162906.mail.bf1.yahoo.com>
 <9EDDE77AB269C54AA685BE1F72B5CA3B08757F@DEN-EXDDA-S21.corp.ebay.com>
Message-ID: <1373513843.5386.YahooMailNeo@web162902.mail.bf1.yahoo.com>
Date: Wed, 10 Jul 2013 20:37:23 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Connecting to a remote db server
To: "Struckhoff, Kevin" <kstruckhoff@ebay.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <9EDDE77AB269C54AA685BE1F72B5CA3B08757F@DEN-EXDDA-S21.corp.ebay.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

"Struckhoff, Kevin" <kstruckhoff@ebay.com> wrote:
> From: Kevin Grittner [mailto:kgrittn@ymail.com]
>> "Struckhoff, Kevin" <kstruckhoff@ebay.com> wrote:

>>> I've installed postgres 9.2 on a server, call it db01. I now want
>>> to access postgres from my app server, call it app01.

>>> It seems that something else is missing or needs to be done.

>> How are you trying to connect, and what happens when you try?

> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
>=A0=A0=A0=A0=A0=A0=A0=A0 Is the server running locally and accepting
>=A0=A0=A0=A0=A0=A0=A0=A0 connections on Unix domain socket "/tmp/.s.PGSQL.=
5432"?

Since you didn't specify a host, it's looking on your local
machine.=A0 What happens if you run?:

psql -h app01 test

You can look at the connection options by running:

psql --help

... or by reading the docs:

http://www.postgresql.org/docs/current/interactive/app-psql.html

... or by using the man page, if available.

By the way, I believe that most server distributions include all
the client software, but you could probably find a client-only
package on most platforms.

--=20
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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