| From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | Brajendra Pratap Singh <bpsinghjobs(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql Backup Encryption |
| Date: | 2020-07-10 07:52:55 |
| Message-ID: | 9EFBC65C-D90E-4FD3-8600-EAC5E066BB10@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Singh,
> On 10. Jul, 2020, at 07:29, Brajendra Pratap Singh <bpsinghjobs(at)gmail(dot)com> wrote:
>
> Hi,
>
> Please let me know the way to encrypt/decrypt the postgresql backup uaing pg_dump and pgbackrest.
>
> Also let me know the other good possibility if any.
>
> Thanks,
> Singh
don't use the -f option with pg_dump and simply pipe the output through your favorite encryption tool. Or use -f option and after pg_dump finishes, encrypt the resulting dump file. These are the two options you have. There is no direct command line option to encrypt pg_dump's output.
https://www.postgresql.org/docs/current/app-pgdump.html
Cheers,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brajendra Pratap Singh | 2020-07-10 08:26:25 | Wal_keep_segment value too high |
| Previous Message | Paul Förster | 2020-07-10 07:45:27 | Re: Safe switchover |