Re: Postgresql Backup Encryption - Mailing list pgsql-general

From Paul Förster
Subject Re: Postgresql Backup Encryption
Date
Msg-id 9EFBC65C-D90E-4FD3-8600-EAC5E066BB10@gmail.com
Whole thread Raw
In response to Postgresql Backup Encryption  (Brajendra Pratap Singh <bpsinghjobs@gmail.com>)
List pgsql-general
Hi Singh,

> On 10. Jul, 2020, at 07:29, Brajendra Pratap Singh <bpsinghjobs@gmail.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
andafter pg_dump finishes, encrypt the resulting dump file. These are the two options you have. There is no direct
commandline option to encrypt pg_dump's output. 

https://www.postgresql.org/docs/current/app-pgdump.html

Cheers,
Paul


pgsql-general by date:

Previous
From: Paul Förster
Date:
Subject: Re: Safe switchover
Next
From: Brajendra Pratap Singh
Date:
Subject: Wal_keep_segment value too high