[ADMIN] Encrypting PGBouncer to Postgres DB connections

2013-04-10 Thread Bhanu Murthy
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

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

2013-05-07 Thread Bhanu Murthy
Here is my understading of your requirement:   machine-A at customer site would replicate to staging machine-B which will then replicate to target machine-C in cloud - and you would want to encrypt data in motion from A to B to C.   I could think of 2 possible solutions:   1. Use Stunnel from mac

[ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

2013-10-01 Thread Bhanu Murthy
Hi all, greetings!   Using Oracle Heterogeneous Services (Oracle HS) I have configured/created a DB link from Postgres 9.3 database into Oracle 11gR3 database (with postgres DB user credentials).  SQL>  create public database link pg_link connect to "postgres" identified by "blahblah" using 'pos