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
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
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.
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
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
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
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