Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ux2oW-00014T-DM for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jul 2013 22:24:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ux2oV-0001Vn-Qr for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jul 2013 22:24:43 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ux2oU-0001U9-62 for pgsql-admin@postgresql.org; Wed, 10 Jul 2013 22:24:42 +0000 Received: from nm41-vm10.bullet.mail.bf1.yahoo.com ([216.109.114.139]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ux2oR-000100-4W for pgsql-admin@postgresql.org; Wed, 10 Jul 2013 22:24:41 +0000 Received: from [98.139.214.32] by nm41.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2013 22:24:38 -0000 Received: from [98.139.212.200] by tm15.bullet.mail.bf1.yahoo.com with NNFMP; 10 Jul 2013 22:24:38 -0000 Received: from [127.0.0.1] by omp1009.mail.bf1.yahoo.com with NNFMP; 10 Jul 2013 22:24:38 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 37307.5612.bm@omp1009.mail.bf1.yahoo.com Received: (qmail 3656 invoked by uid 60001); 10 Jul 2013 22:24:38 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1373495077; bh=N/srlgsiXUMqvuOj5y19eUtnKaLJH2k6/uLdkhE/Tw4=; 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; b=Af4wCcPeZ/FlhVRDF31TNLDkdxcs9v0pFyahqvZSGO+4YOirwKeFtNR0C/usqqKyulS24twdPpY7ZZjD5uK59Q/H0gSwelHQWp8zGc3IgYigNj62eWcCn3zmxjUjljsNi52/LmNvGqVsx8g7vrPNWvMemPYxLmMo+9eMU4td+VI= 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; b=0isQmuG4aUTqltoMCRSdAByLKbRmD+o6hs6OHKpRlixTyWTmyFfsnNA4XvxEASzEmII4uDfMJt4EsdM09HqExAZUO9kWVGXJ/P7KGAvabfnhWae3lgzxaRvjqiPpKtafE1E0j6hdAbRubrVYjzLZSVTKZHF+G2k2kWrSvRKvQ2g= ; X-YMail-OSG: abzezQcVM1l1M8T3VjU9KTgNvB1yCVGsO8P_IT1myVwS6AJ voT.ERztwwLKedIkMefKmVcYzoXh9ORklGxKiIRQGSMNv4M11VlIElGUG59V hRXWmgQn8kt9pDbr7vC3q7dM2pVHOf2L3HUBzwrToEFKbECyvPWmz5qCNS97 _JWraDree58eVrEIf4tNXo0xq2e60559pKt8_PHtmaeGfWdPrUxSpvdukUQS .f8m7lVa1FJSlMkRklsQMYAcDJBi_ECPx6_Cu5gnSd8ZBMo0jwCYcqwYM8ty 7w3tsbwLeBTNqUy5_KES9UFusczm5kfnITX_qxZ2brL.NXzhekmygnILgNL0 NdNLmxOTMRpDfxBLXrPoqUKiIqneEJNqKtt044ryP_LpAjNdMmCORUKE31pG m0QmrYLRq2u4d9FsQGhZjMsC_tOEzG0DSIy01ozG5Ij6.Gt_5nVqAAotVMSo B45kPBn0fmq0aE0tJrqnWz.BWu.sYVf_iOTf5bawMaJKYB_QMjLW8LmLGs7A caKzY8zCDp_2xltw3LgUV6XvdkDquQR.aq_uFyXe34LOYvZRCFGlciHdS04L Bt51vHIIrGPlMsNlm0KLL93nptUZ5YcGQeV6IkUNCDU5ayo9RkWHvwc3I6CZ 2gbgtX3iJPMQm0KhBhsKk0KmKkz0ZomneRQ2YWQ6feUrQivr7gbDtFBunDnO wh2kP4wxQgK8.pRD1D1XtIgaZyRtI9d5vpHjnKBoZyH.9T4PmUm4- Received: from [76.255.18.237] by web162906.mail.bf1.yahoo.com via HTTP; Wed, 10 Jul 2013 15:24:37 PDT X-Rocket-MIMEInfo: 002.001, IlN0cnVja2hvZmYsIEtldmluIiA8a3N0cnVja2hvZmZAZWJheS5jb20.IHdyb3RlOgoKPiBJJ3ZlIGluc3RhbGxlZCBwb3N0Z3JlcyA5LjIgb24gYSBzZXJ2ZXIsIGNhbGwgaXQgZGIwMS4gSSBub3cgd2FudAo.IHRvIGFjY2VzcyBwb3N0Z3JlcyBmcm9tIG15IGFwcCBzZXJ2ZXIsIGNhbGwgaXQgYXBwMDEuCj4gCj4gV2hhdCBkbyBJIGluc3RhbGwgb24gdGhlIGFwcDAxIHNlcnZlcj8gSSd2ZSBpbnN0YWxsZWQgcG9zdGdyZXMKPiA5LjIgb24gaXQgYW5kIHNldCB0aGUgcG9zdGdyZXNlc3FsLmNvbmYgZmlsZScBMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 References: <9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com> Message-ID: <1373495077.98876.YahooMailNeo@web162906.mail.bf1.yahoo.com> Date: Wed, 10 Jul 2013 15:24:37 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Connecting to a remote db server To: "Struckhoff, Kevin" , "pgsql-admin@postgresql.org" In-Reply-To: <9EDDE77AB269C54AA685BE1F72B5CA3B0873A4@DEN-EXDDA-S21.corp.ebay.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "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. 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin