Postgresql Backup Encryption

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 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