Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lEhUV-0006R3-Ev
	for pgsql-admin@arkaria.postgresql.org; Tue, 23 Feb 2021 23:53:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lEhUT-0002yo-B1
	for pgsql-admin@arkaria.postgresql.org; Tue, 23 Feb 2021 23:53:17 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vipin.madhusoodanan@gmail.com>)
	id 1lEhUT-0002yh-0F
	for pgsql-admin@lists.postgresql.org; Tue, 23 Feb 2021 23:53:17 +0000
Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <vipin.madhusoodanan@gmail.com>)
	id 1lEhUN-0000fh-IV
	for pgsql-admin@lists.postgresql.org; Tue, 23 Feb 2021 23:53:15 +0000
Received: by mail-io1-xd33.google.com with SMTP id k17so126428ioc.5
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 23 Feb 2021 15:53:11 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=content-transfer-encoding:from:mime-version:date:subject:message-id
         :to;
        bh=VSm1mqd9uctr89Ri60+pA/hbd6qV1WkztK8ePModM7c=;
        b=jwK/5i6ftE2d2f53Zof6d3mz7AthH+KQeSbC1tiAJYAjmfLoeUt2tK+TWgfxlhcTcv
         ZDVdSDiw6l6Wm0xFO/CRaYKVPsBXQCQtaQYdiamFYWK33HyyaP9n5irBUx9tKXIgU08j
         6ArDhJdKIR5c3rZu4Usayhxc3Xpj7O2P6QD1M4+rjULyn2ABhMBXfhNkiuAOyvJtUjVr
         thUSUU4lsef9TSxYdxAaVdbanU54u74CyJMOIWwZa489hf/UD07lqGJLPZwwJhLGLI0J
         oshniAkPsEypYglsejU+0MmxfiFVr3vHXhtatihSOcwt+YTTcNYsPgmpEc6Aohp/o1Db
         WTrA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:content-transfer-encoding:from:mime-version:date
         :subject:message-id:to;
        bh=VSm1mqd9uctr89Ri60+pA/hbd6qV1WkztK8ePModM7c=;
        b=HzEgpy6gfWPkFIH6BGLPmNoIpsp87ao6bHJDBpm1DiNqvTmzBnaM1apZu67mgqdtUg
         JMqXJtrkWkTwaf0RS9T1Ge4EULpcX3k8YFDiLew4RSTUtSvZXVL546+0r9AFliV175YP
         zQ48VuCDvwLDSDMiGTbMg1rPU1w4r3xOuhla/ZNQLmAfXmvs3haXZQE1Dx1FIhKvTAhg
         2FxG8tN/GEm+yksaty19eR3TdHQV0lMjSd6gEJKZZdqmyozTYZhFBVablskI9BGsygoe
         +bVhokfoYoKPh0o2twa1aUjMiitGsF4wRcZk9jqY3tpQBar9qZw3zvdZV182V6cuo/ZP
         rLrw==
X-Gm-Message-State: AOAM532SU6uDgR7QqESb2jSDeoxxuJIDyM6djRNuPbRZikSJ7lYJ7Hzq
	rEK0LKw/sCcRl1LKvQp8Fi6gpJ/9jvVTNQ==
X-Google-Smtp-Source: 
 ABdhPJwU3c5Vc05WCxcuPOMlMeW/mFrQ7Mlhfm0wFNkHczdXBcrWXR4CR6nHBecnfmgc7b5TJq5Qag==
X-Received: by 2002:a02:74a:: with SMTP id f71mr29288000jaf.30.1614124389889;
        Tue, 23 Feb 2021 15:53:09 -0800 (PST)
Received: from ?IPv6:2604:2d80:5d86:5d00:288f:dca4:21ec:54ee?
 ([2604:2d80:5d86:5d00:288f:dca4:21ec:54ee])
        by smtp.gmail.com with ESMTPSA id l7sm190784iln.74.2021.02.23.15.53.08
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Tue, 23 Feb 2021 15:53:09 -0800 (PST)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
From: Vipin Madhusoodanan <vipin.madhusoodanan@gmail.com>
Mime-Version: 1.0 (1.0)
Date: Tue, 23 Feb 2021 17:53:04 -0600
Subject: How to encrypt password in pgpass file
Message-Id: <DCB731A2-6896-4669-A6C1-69D5A730829B@gmail.com>
To: pgsql-admin@lists.postgresql.org
X-Mailer: iPhone Mail (18D52)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Hi Team,

We have a security requirement to encrypt passwords in .pgpass file. Could y=
ou please advise on the options and steps to be followed to achieve this.

Thanks,
Vipin

Sent from my iPhone=