CREATE DATABASE ENCRYPTED ?

Started by Berend Toberalmost 22 years ago2 messagesgeneral
Jump to latest
#1Berend Tober
btober@seaworthysys.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Berend Tober (#1)
Re: CREATE DATABASE ENCRYPTED ?

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