From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Struckhoff, Kevin <kstruckhoff@ebay.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Connecting to a remote db server
Date: Wed, 10 Jul 2013 18:22:57 -0400
Message-ID: <20130710222257.GE4941@eldon.alvh.no-ip.org> (raw)
In-Reply-To: <9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com>
References: <9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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_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.
>
> 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, kstruckhoff@ebay.com
Subject: Re: Connecting to a remote db server
In-Reply-To: <20130710222257.GE4941@eldon.alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox