Re: Connecting to a remote db server

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..

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: Kevin Grittner [mailto:kgrittn(at)ymail(dot)com]
Sent: Wednesday, July 10, 2013 3:25 PM
To: Struckhoff, Kevin; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Connecting to a remote db server

"Struckhoff, Kevin" <kstruckhoff(at)ebay(dot)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.
>
> What do I install on the app01 server? I've installed postgres
> 9.2 on it and set the postgresesql.conf file's listen_address to
> a value of '*' on both machines. I've also modified the
> pg_hba.conf file to be wide open for now on both machines.

The postgresesql.conf and pg_hba.conf files aren't used on the
client side -- those only matter on the server.

> It seems that something else is missing or needs to be done.
> Googling wasn't much help, the results weren't current.

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

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

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