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 1jt99v-0007zr-Pw for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 12:26:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jt99u-0003eb-MB for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 12:26:42 +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 1jt99u-0003eU-Cb for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 12:26:42 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jt99r-0007SE-Q7 for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 12:26:42 +0000 Received: by mail-ot1-x335.google.com with SMTP id g37so13038779otb.9 for ; Wed, 08 Jul 2020 05:26:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=RjT3ur2JJAqlqI0UDjIPPxvquk1XVwSvdrm50LuBkxw=; b=UXT8Ph/ywc38W/636RTX+GXJNaqlpE/iscqBH9dkehhtV3cJ3PWKAw5LmoqVdknw8n WU6pIwLETA4nC6JBUPX4lNKDB7sG6Z1Dvvdr+xo0G4/EVeW0up9OFp5rD/LYY2kDoKFs DY1QObI5GK+j/RckQl0KMl9kca1IYetC0Yulyjh9Km1A8kJ9LX6fzpSFiOrcHZsE5eiZ cBmG3p1gmbrIBn1aMRK9m7lEGDHUOWqSYoVxcnuvjb5ULVGJPYuQwlx46TGkTs30vjT2 LWM56bULTTiD/MaMat5MCudk7m49+e1ra3QKYQcA29mUvd7pjB1e7603Pd7RQCPwk4TE ndNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=RjT3ur2JJAqlqI0UDjIPPxvquk1XVwSvdrm50LuBkxw=; b=URf+w9SmSI4rP/5d4N7KhZ+5KZQYFMcgJLGhQUxpOy7/IYo4r8el6RANhAtAvXrkrj jYgpN+oPWP+O9qChzh+E5wUrh2QtHc7+mAZA1Qk7645OxeF50P+XbC2YgxJ7Iey5Le58 DBQ1GRyeiztxycZfE8ekabIwvF4ErIa8Y7k32/QzdXUvWAwwJ7PY9SiB7/XGEMw8wNxF RW3rtE9mY6+7GX2Em4bzE4nnl8wzs+Hb+ibKLfPu1SRG1somJnWJ1u2k/NCEzZImC8y1 xgt1vDRsDOIOmgnavruFRd6kDVwlIo6WeYEoJvQF/g4UOjanl+tJvkfKbrK7gjop5DoR MqPw== X-Gm-Message-State: AOAM531xD4Fp6fuEz3DhQwzw6u7qs5+QHz6Jdm6Hl0RDmdYNZB0DDeP1 jsuuusXF24MzFSKAlDdhS7jKe2kAfDwbOw== X-Google-Smtp-Source: ABdhPJw6xqVPhabpGfH8wBd8U0ETnUN/ro97mhZfiwxsypRomO/e8/hC24QOWGpR0Z9lW/hELbhvxg== X-Received: by 2002:a9d:5e5:: with SMTP id 92mr38598132otd.9.1594211197453; Wed, 08 Jul 2020 05:26:37 -0700 (PDT) Received: from [192.168.1.10] (ip70-186-126-197.no.no.cox.net. [70.186.126.197]) by smtp.googlemail.com with ESMTPSA id b14sm6475455ots.76.2020.07.08.05.26.36 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Jul 2020 05:26:36 -0700 (PDT) Subject: Re: Encryption password for Backup To: pgsql-admin@lists.postgresql.org References: <821a67b1-a50c-16fb-a8fb-eb717c467e5e@jakobs.com> From: Ron Message-ID: <3d66648a-de14-e6ce-6933-0131d012cde9@gmail.com> Date: Wed, 8 Jul 2020 07:26:35 -0500 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: <821a67b1-a50c-16fb-a8fb-eb717c467e5e@jakobs.com> Content-Type: multipart/alternative; boundary="------------6BB3FBF51AF2197B1BF7E323" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------6BB3FBF51AF2197B1BF7E323 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Sadly, that wouldn't work too well with --format=directory. On 7/8/20 7:20 AM, Holger Jakobs wrote: > > 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 -- Angular momentum makes the world go 'round. --------------6BB3FBF51AF2197B1BF7E323 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Sadly, that wouldn't work too well with --format=directory.

On 7/8/20 7:20 AM, Holger Jakobs wrote:

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

--
Angular momentum makes the world go 'round.
--------------6BB3FBF51AF2197B1BF7E323--