Is there any protection for files generated with pg_dump?

Navigation
3

Is there protection for files generated by pg_dump?

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

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

    
asked by anonymous 12.05.2014 / 19:43

1 answer

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

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

Good luck

    
12.05.2014 / 21:08
CheckBoxListFor with error Accentuating files in directory reading