Is there any protection for the files generated with pg_dump?

Asked

Viewed 60 times

3

There is protection of files generated by pg_dump?

Anyone who has access to this file can restore it in any other database with pg_restore?

Is there some protection in this file, some kind of password or something like that?

postgresql postgresql-administration

1 answer

3

Unfortunately there’s nothing native in the postgresql for such purpose, what you can do to "improve" the security of your files, is to use an external program to encrypt them, example:

pg_dump -U postgres ... | encrypt  > meu-arquivo.sql.dump

Good luck

  • I get it, thank you.

Browser other questions tagged postgresql postgresql-administration

You are not signed in. Login or sign up in order to post.