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 i

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.