Sorry, rhel 5.8. so there is a separate client install package?
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckhoff@ebay.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
namedin 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
deletethe contents of this transmission from your system immediately. Any comments or statements contained in this
transmissiondo not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@2ndquadrant.com]
Sent: Wednesday, July 10, 2013 3:23 PM
To: Struckhoff, Kevin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server
Struckhoff, Kevin 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_addressto a value of '*' on both machines. I've also modified the pg_hba.conf file to be wide open for now on
bothmachines.
>
> It seems that something else is missing or needs to be done. Googling wasn't much help, the results weren't current.
What's your operating system? There are two separate pieces, client and
server. On the application side you don't need the server packages, so
normally there's no postgresql.conf file there at all, and no
pg_hba.conf either; both are server-side only configuration files. You
just need libpq, and whatever client libraries your apps use.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
