Postgres Pro
Downloads
Home   >   mailing lists

Thread: Encryption password for Backup

Encryption password for Backup

From
Mayur Mundada
Date:
Hello Team,

I need to confirm about Encryption password for Backups. Can we use Encryption password while taking pg_dump backup and restore backup purpose. If it is possible please let me know the methods and guidance for the same. 

Regards,
Mayur Mundada
9860900093

Re: Encryption password for Backup

From
Holger Jakobs
Date:

Dear Mayur,

The easiest way is to pipe the result of pg_dump through some encrypting program.

pg_dump | encryptProgram > encrypted.dump

Regards,

Holger


Am 08.07.20 um 05:20 schrieb Mayur Mundada:
Hello Team,

I need to confirm about Encryption password for Backups. Can we use Encryption password while taking pg_dump backup and restore backup purpose. If it is possible please let me know the methods and guidance for the same. 

Regards,
Mayur Mundada
9860900093
-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Re: Encryption password for Backup

From
Ron
Date:
Sadly, that wouldn't work too well with --format=directory.

On 7/8/20 7:20 AM, Holger Jakobs wrote:

Dear Mayur,

The easiest way is to pipe the result of pg_dump through some encrypting program.

pg_dump | encryptProgram > encrypted.dump

Regards,

Holger


Am 08.07.20 um 05:20 schrieb Mayur Mundada:
Hello Team,

I need to confirm about Encryption password for Backups. Can we use Encryption password while taking pg_dump backup and restore backup purpose. If it is possible please let me know the methods and guidance for the same. 

Regards,
Mayur Mundada
9860900093
-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

--
Angular momentum makes the world go 'round.

Re: Encryption password for Backup

From
Mayur Mundada
Date:
Any update on this? I am waiting for your reply.

On Wed, Jul 8, 2020, 8:50 AM Mayur Mundada <mundada.mayur24@gmail.com> wrote:
Hello Team,

I need to confirm about Encryption password for Backups. Can we use Encryption password while taking pg_dump backup and restore backup purpose. If it is possible please let me know the methods and guidance for the same. 

Regards,
Mayur Mundada
9860900093

Re: Encryption password for Backup

From
Scott Ribe
Date:
> On Jul 18, 2020, at 9:13 AM, Mayur Mundada <mundada.mayur24@gmail.com> wrote:
>
> Any update on this? I am waiting for your reply.

pg_dump does not encrypt; you can pipe its output into any encryption utility you want to