Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YRAqw-00057J-G2 for pgsql-admin@arkaria.postgresql.org; Fri, 27 Feb 2015 02:40:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YRAqv-0003SN-Nb for pgsql-admin@arkaria.postgresql.org; Fri, 27 Feb 2015 02:40:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YRAqu-0003SB-Pk for pgsql-admin@postgresql.org; Fri, 27 Feb 2015 02:40:32 +0000 Received: from mail-yk0-x22c.google.com ([2607:f8b0:4002:c07::22c]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YRAqn-0000Xr-1C for pgsql-admin@postgresql.org; Fri, 27 Feb 2015 02:40:30 +0000 Received: by ykbq200 with SMTP id q200so6008422ykb.2 for ; Thu, 26 Feb 2015 18:40:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=hjm2rEG50HqQdHCfVXbGL7dPp+ryYruV3HfUpEHoHZI=; b=kxJMD3C2ceXRf9gQr5Jw2pW+djerEuKB0h57/o4jqzQTlIMOkSi0fH3z+TrytvEnus M63wKztR2w2QZ26XH1ru69QL0SK3yjETp+P6+03oRI80ZrOoKYbMsceKudP82Pyfygt+ G1HL71LjQb/xsO+alLtw3cY0r86EI0VB31qwovorri9wofBik+3VLf0lQko7eLFBTg46 GIx7wBS0xdyKI0vrsKNC8VB0w8xQff44jFu6UkJ/TlvSugZIZEaiXJVh+tG507sErSM+ 0VT8OFKWgOoB2t+BncdpMq2cEGIvOdUEtzFVuaaS34IaGNycl4qqGP4Q9z3SY36MSJ3Q qHpg== X-Received: by 10.170.47.8 with SMTP id 8mr11484970ykp.18.1425004824121; Thu, 26 Feb 2015 18:40:24 -0800 (PST) Received: from [192.168.254.3] (h77.89.102.166.static.ip.windstream.net. [166.102.89.77]) by mx.google.com with ESMTPSA id v18sm2146933yha.16.2015.02.26.18.40.22 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 26 Feb 2015 18:40:23 -0800 (PST) Message-ID: <54EFD910.5020501@gmail.com> Date: Thu, 26 Feb 2015 21:40:16 -0500 From: John Scalia User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: Scott Ribe CC: "pgsql-admin@postgresql.org" Subject: Re: Security with V9.3.3 standby servers References: <54EF46B7.3000809@gmail.com> <2645DF43-00E0-4AEB-B02F-DD8AE703528A@elevated-dev.com> In-Reply-To: <2645DF43-00E0-4AEB-B02F-DD8AE703528A@elevated-dev.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 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 this to 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. > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin