CODEWITHSUNDEEP
postgresqlsecuritybackuppassword-protection
anil
anil

Reputation: 668

how to make the postgre SQL backup password protected

I am backing postgre SQL db using pgadmin.

However, while the db has a password the backup file has no protection. The backup file can be taken and restored to any blank database without any password !!

How do I make the backup secure / password protected? Thanks.

Upvotes: 4

Views: 5387

Answers (2)

A. Scherbaum
A. Scherbaum

Reputation: 855

You might want to use a tool which supports streaming encryption - and avoid writing your plain text backup to disk. Also don't use pgAdminIII, but use pg_dump instead, and pipe the backup output into your encryption program, and write the result to disk.

Upvotes: 0

Craig Ringer
Craig Ringer

Reputation: 325001

PostgreSQL and PgAdmin have no built-in facility for backup encryption and password protection.

There are numerous ways you can encrypt backups. You can use gnupg, but I suspect you will be happier using a zip utility that supports encryption. I recommend 7zip, which supports the zip64 format and zip file encryption.

Upvotes: 2

Related Questions