CREATE DATABASE ENCRYPTED ?
I apologize in advance if I'm remembering incorrectly or am missing
something right under my nose, but I thought there used to be an option
for creating a database or table in which all the data was stored
encrypted, something like "CREATE DATABASE dbname ENCRYPTED" or "CREATE
TABLE tname ENCRYPTED", but now I can't find that in the documentation
anywhere. The only thing close I've located is the "ENCRYPTED" option for
the password in "CREATE USER". I know there is the pg_cyrpt library for
and related functions, but where (if it exists) is that functionality for
database-wide encryption ... or am I thinking of some database product
other than Postgresql?
--
Berend Tober
btober@seaworthysys.com writes:
I apologize in advance if I'm remembering incorrectly or am missing
something right under my nose, but I thought there used to be an option
for creating a database or table in which all the data was stored
encrypted, something like "CREATE DATABASE dbname ENCRYPTED" or "CREATE
TABLE tname ENCRYPTED", but now I can't find that in the documentation
anywhere.
Nope, never been any such thing in Postgres --- maybe you're thinking of
the facility for encrypted passwords?
My suggestion would be to use an encrypting filesystem layer.
regards, tom lane