I have present my database and I have encrypt the complete database is there any way to encrypt database ? Version : Postgres 9.6
-
1Use an encrypted filesystem?user330315– user3303152019-10-07 10:42:34 +00:00Commented Oct 7, 2019 at 10:42
-
I have encrypt the database then if anyone fire any query then data should show encrypted formatkunal wani– kunal wani2019-10-07 10:51:08 +00:00Commented Oct 7, 2019 at 10:51
-
If you want to encrypt data on column level, you need to do that yourself, e.g. using pgcryptouser330315– user3303152019-10-07 11:04:22 +00:00Commented Oct 7, 2019 at 11:04
-
stackoverflow.com/questions/26376605/…user330315– user3303152019-10-07 11:08:22 +00:00Commented Oct 7, 2019 at 11:08
-
1How do you plan do decrypt the content? If everything is encrypted, then how do you maintain foreign keys? If the contents is decrypted, then how do you plan to search inside the content? What kind of threat are you expecting that can be prevented using encrypted data?user330315– user3303152019-10-07 13:25:31 +00:00Commented Oct 7, 2019 at 13:25
|
Show 3 more comments