Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UPza5-0007TL-JS for pgsql-admin@arkaria.postgresql.org; Wed, 10 Apr 2013 18:17:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UPza4-0001hj-Fh for pgsql-admin@arkaria.postgresql.org; Wed, 10 Apr 2013 18:17:12 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UPzZs-0001XF-7t; Wed, 10 Apr 2013 18:17:00 +0000 Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UPzZp-000654-N9; Wed, 10 Apr 2013 18:16:59 +0000 Received: from pps.filterd (pp2.rice.edu [127.0.0.1]) by pp2.rice.edu (8.14.5/8.14.5) with SMTP id r3A9sga4007667; Wed, 10 Apr 2013 13:16:56 -0500 Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10]) by pp2.rice.edu with ESMTP id 1bmv0w8h65-1; Wed, 10 Apr 2013 13:16:56 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh3.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh3.mail.rice.edu (Postfix) with ESMTP id B725D4012F; Wed, 10 Apr 2013 13:16:56 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id AF6E210063A; Wed, 10 Apr 2013 13:16:56 -0500 (CDT) Date: Wed, 10 Apr 2013 13:16:56 -0500 From: "ktm@rice.edu" To: Bhanu Murthy Cc: "pgsql-admin@postgresql.org" , "pgsql-sql@postgresql.org" Subject: Re: [SQL] Encrypting PGBouncer to Postgres DB connections Message-ID: <20130410181656.GB32580@aart.rice.edu> References: <515AEB4E.9010305@europecamions-interactive.com> <1365617192.69337.YahooMailNeo@web163506.mail.gq1.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <1365617192.69337.YahooMailNeo@web163506.mail.gq1.yahoo.com> User-Agent: Mutt/1.5.20 (2009-12-10) Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by pp2.rice.edu id r3A9sga4007667 X-Pg-Spam-Score: -4.3 (----) 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 On Wed, Apr 10, 2013 at 11:06:32AM -0700, Bhanu Murthy wrote: > Hi all,=20 > =A0 > Can someone please point me to detailed documentation on how to secure/en= crypt connections between PGBouncer and Postgresql database (version 8.4.3)= ?=A0 > =A0 > Thanks in advance! > =A0 > Bhanu M. Gandikota > Cell: (415) 420-7740 Hi Bhanu, You will need to use your link encryption process of choice to tunnel the c= onnections from pgbouncer to the backend. SSH and STunnel are two that we have used su= ccessfully in the past. Regards, Ken --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin