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 ) id 1jt93w-0007qT-7t for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 12:20:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jt93t-0007Uz-Jz for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 12:20:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jt93t-0007SU-C3 for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 12:20:29 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jt93p-0007Ot-7d for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 12:20:27 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id A9F9C380727; Wed, 8 Jul 2020 14:20:23 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PjZr_jmsFPbD; Wed, 8 Jul 2020 14:20:23 +0200 (CEST) Received: from [192.168.178.97] (ip-37-201-154-65.hsi13.unitymediagroup.de [37.201.154.65]) by rs.plausibolo.de (Postfix) with ESMTPSA id 6C6183806D6; Wed, 8 Jul 2020 14:20:23 +0200 (CEST) Subject: Re: Encryption password for Backup To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Message-ID: <821a67b1-a50c-16fb-a8fb-eb717c467e5e@jakobs.com> Date: Wed, 8 Jul 2020 14:20:22 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------CE2F3F2D49A3D6923B1D43D1" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------CE2F3F2D49A3D6923B1D43D1 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Dear Mayur, The easiest way is to pipe the result of pg_dump through some encrypting program. pg_dump | encryptProgram > encrypted.dump Regards, Holger Am 08.07.20 um 05:20 schrieb Mayur Mundada: > Hello Team, > > I need to confirm about Encryption password for Backups. Can we > use Encryption password while taking pg_dump backup and restore backup > purpose. If it is possible please let me know the methods and guidance > for the same.  > > Regards, > Mayur Mundada > 9860900093 -- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 --------------CE2F3F2D49A3D6923B1D43D1 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Dear Mayur,

The easiest way is to pipe the result of pg_dump through some encrypting program.

pg_dump | encryptProgram > encrypted.dump

Regards,

Holger


Am 08.07.20 um 05:20 schrieb Mayur Mundada:
Hello Team,

I need to confirm about Encryption password for Backups. Can we use Encryption password while taking pg_dump backup and restore backup purpose. If it is possible please let me know the methods and guidance for the same. 

Regards,
Mayur Mundada
9860900093
-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------CE2F3F2D49A3D6923B1D43D1--