pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: AJ Weber <aweber@comcast.net>
To: pgsql-admin@postgresql.org
Subject: Re: Encrypting PGBouncer to Postgres DB connections
Date: Wed, 10 Apr 2013 14:15:30 -0400
Message-ID: <5165AC42.4080109@comcast.net> (raw)
In-Reply-To: <1365617192.69337.YahooMailNeo@web163506.mail.gq1.yahoo.com>
References: <515AEB4E.9010305@europecamions-interactive.com>
	<CALxYTP6sxtHSwfFk2C3n4cV59NNPcg2Po9R04SM8W9WTR1ThWw@mail.gmail.com>
	<1365617192.69337.YahooMailNeo@web163506.mail.gq1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

AFAIK, you have to use stunnel to do it (which is not hard to setup, but 
it almost makes you wonder whether you should go to the trouble of using 
pgbouncer at all).

I just went through this and I ended up just testing direct connections 
through the tunnel without pgbouncer in the middle.  It worked for the 
most part.  I had some unexplained issues with my app that I couldn't 
pinpoint so I stopped testing it for a while.  (And my app already does 
connection pooling, so pgbouncer wasn't going to help that much in that 
regard.)


On 4/10/2013 2:06 PM, Bhanu Murthy wrote:
> Hi all,
> Can someone please point me to detailed documentation on how to 
> secure/encrypt connections between PGBouncer and Postgresql database 
> (version 8.4.3)?
> Thanks in advance!
> Bhanu M. Gandikota
> Cell: (415) 420-7740

view thread (9+ messages)  latest in thread

Message-ID: <5165AC42.4080109@comcast.net>
Permalink:  ../5165AC42.4080109@comcast.net/
Also on:    postgresql.org/message-id/5165AC42.4080109@comcast.net

 · 

reply

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-sql@postgresql.org
  Cc: aweber@comcast.net, pgsql-admin@postgresql.org
  Subject: Re: Encrypting PGBouncer to Postgres DB connections
  In-Reply-To: <5165AC42.4080109@comcast.net>

* 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