I want to have the whole database to be encrypted, instead of encrypting the data before storing into database.
Is it possible to encrypt the whole postgres database and what best method to use?
Thanks :)
Take the 2-minute tour
×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
PostgreSQL doesn't currently support DB-level encryption. (Correct as of 9.4, at least). You can use an encrypted file system, though the performance impact can be pretty serious for write-heavy systems, especially those doing random I/O. Your options depend on the operating system - Microsoft BitLocker, Linux's dm-crypt/LUKS/cryptsetup, OS X's FileVault 2, etc. Alternately, look at PgCrypto for field-level encryption, but beware of key-disclosure issues in logging and See also: |
||||
|
|
