Re: Security with V9.3.3 standby servers - Mailing list pgsql-admin

From John Scalia
Subject Re: Security with V9.3.3 standby servers
Date
Msg-id 54EFD910.5020501@gmail.com
Whole thread Raw
In response to Re: Security with V9.3.3 standby servers  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Ahhh, I hadn't considered that. Thanks, I think I'll try that tomorrow morning.

On 2/26/2015 4:57 PM, Scott Ribe wrote:
> On Feb 26, 2015, at 9:15 AM, John Scalia <jayknowsunix@gmail.com> wrote:
>> An edict has been handed down here from on high that no script shall ever contain any password in cleartext for any
reason.Well this is problem with a streaming replication standby server's recovery.conf file as the line
primary_conninfo= contains said replication user's password for that connection. Is there any sort of plan to allow
thisto be md5 or some such encoded? Or what else could I do in this case? 
> I have replica standbys that are firewalled from the primary. The primary establishes a reverse SSH tunnel to the
replica,then the replica is configured as for a local connection on-server at the primary, just using UNIX identity. 
>



pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Security with V9.3.3 standby servers
Next
From: Vinaya Torne
Date:
Subject: How to execute cursor in PostgreSQL?