From: Paul Förster <paul.foerster@gmail.com>
To: vinod kale <vinod16895@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Encryption in pg_dump
Date: Mon, 20 Jul 2020 15:24:16 +0200
Message-ID: <2BCA8D4B-E94D-4F2F-99A5-D783912A1CDF@gmail.com> (raw)
In-Reply-To: <CAD7GeHRZ3tu8y9VG_0juVK3RQq6r+t6HciguEz_C8Eh85Hmq3A@mail.gmail.com>
References: <CAD7GeHRZ3tu8y9VG_0juVK3RQq6r+t6HciguEz_C8Eh85Hmq3A@mail.gmail.com>
Hi Vinod,
> On 20. Jul, 2020, at 14:40, vinod kale <vinod16895@gmail.com> wrote:
>
> Hello Team,
>
> I am using postgresql 10.8 version in our prod environment. We take dump backup on daily basis of full database. And this dump backup creates in human readable format.
> My requirement is backup should creates in encrypted format at the time of pg_dump running.
> Is there any way or any option available in pg_dump that will creates the backup in encrypted format or any tool available for same.
sorry, no way. The only way you have is to pipe the output of pg_dump through some encryption tool. pg_dump does not offer to create encrypted dumps directly using some command line option.
Cheers,
Paul
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: paul.foerster@gmail.com, vinod16895@gmail.com
Subject: Re: Encryption in pg_dump
In-Reply-To: <2BCA8D4B-E94D-4F2F-99A5-D783912A1CDF@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox