From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
Cc: | vinod kale <vinod16895(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Encryption in pg_dump |
Date: | 2020-07-22 18:55:41 |
Message-ID: | 20200722185541.GE3899@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Jul 20, 2020 at 03:24:16PM +0200, Paul Förster wrote:
> Hi Vinod,
>
> > On 20. Jul, 2020, at 14:40, vinod kale <vinod16895(at)gmail(dot)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.
Does anyone know why we are getting so many requests for encrypting
dumps all of a sudden?
July 20 CAD7GeHRZ3tu8y9VG_0juVK3RQq6r+t6HciguEz_C8Eh85Hmq3A(at)mail(dot)gmail(dot)com
July 10 CALLD-SGTbu0HCW8NGVg+ycC8PKn9opcbN7aw4CvLj3OVC-hw=Q(at)mail(dot)gmail(dot)com
July 8 CAFiui6G0sgLoURsK61vmiPR1Amd7PQt82cvgdmZ7+ukdsbV1QQ(at)mail(dot)gmail(dot)com
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2020-07-22 20:05:35 | Re: Encryption in pg_dump |
Previous Message | Bruce Momjian | 2020-07-22 18:42:25 | Re: More efficient access of JSON array elements? |