Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread Albe Laurenz
Bhanu Murthy wrote: handsfree wrote: We're looking to use streaming replication to a target via a secondary host using stunnel. I could think of 2 possible solutions: [...] 2. Use streaming replication config features to secure traffic (encrypted data over TCP) Master configuration

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread handsfree
Thanks for the response. In terms of your suggestions: 1. We already have stunnel installed on MachineA and MachineB, and it would not be too difficult to install stunnel on MachineC either. What I'm unsure of is how to make MachineB a 'bridge' so the postgres target MachineC appears as an end

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread handsfree
Laurenz, thanks for that information; I will bear in mind the problems that you encountered with SSL renegotiation. I'm not sure that this will necessarily be an issue using stunnel, but I will talk with my colleagues who have more experience of stunnel and confirm whether or not it's applicable.

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread Albe Laurenz
handsfree wrote: Laurenz, thanks for that information; I will bear in mind the problems that you encountered with SSL renegotiation. I'm not sure that this will necessarily be an issue using stunnel, but I will talk with my colleagues who have more experience of stunnel and confirm whether

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-07 Thread handsfree
We're looking to use streaming replication to a target via a secondary host using stunnel. I'd love to hear how you were able to achieve this, k...@rice.edu. Effectively we're looking to have the database on our customer's site (let's call that MachineA) replicate to our backend postgres target

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-07 Thread Bhanu Murthy
To: pgsql-admin@postgresql.org Sent: Tuesday, May 7, 2013 9:17 AM Subject: Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections We're looking to use streaming replication to a target via a secondary host using stunnel.  I'd love to hear how you were able to achieve this, k...@rice.edu

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-04-10 Thread k...@rice.edu
On Wed, Apr 10, 2013 at 11:06:32AM -0700, 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