Connecting to a remote db server - Mailing list pgsql-admin

From Struckhoff, Kevin
Subject Connecting to a remote db server
Date
Msg-id 9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com
Whole thread Raw
Responses Re: Connecting to a remote db server  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Connecting to a remote db server  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-admin

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.

 

Any help would be appreciated. Thanks.

 

 

Kevin Struckhoff

kstruckhoff@ebay.com

 

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Upgrading from 9.1 to 9.2 - master AND slave
Next
From: Alvaro Herrera
Date:
Subject: Re: Connecting to a remote db server