Search code examples
postgresqlsecuritybackuppassword-protection

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.

Solution

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