| From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | vinod kale <vinod16895(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Encryption in pg_dump |
| Date: | 2020-07-20 13:24:16 |
| Message-ID: | 2BCA8D4B-E94D-4F2F-99A5-D783912A1CDF@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
Cheers,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian xu | 2020-07-20 21:33:55 | Re: checkpoint process use too much memory |
| Previous Message | vinod kale | 2020-07-20 12:40:36 | Encryption in pg_dump |