Tagged Questions
3
votes
1answer
100 views
Database encryption and key management with pg_crypto
I am looking at the possibility of having to store root passwords for virtual machines in reversibly encrypted format in a database. The reason is that local logins will sometimes be required to ...
4
votes
1answer
2k views
How to use aes-encryption in PostgreSQL?
I tried aes-encryption by using following statement:
SELECT encrypt('test', 'key', 'aes');
which worked, but I am not able to decrypt the value. I inserted it in a field of datatype bytea but I'm ...
4
votes
1answer
193 views
Can you make SSL and SSL-only (hostssl) connections to PGPool?
The new version of PGPool (3.2) has an "SSL" section in the conf file, and directions on how to use it in the manual. However, pool_hba.conf specifically says that PGPool doesn't support SSL (i.e. ...
0
votes
1answer
256 views
Two-way encryption in PostgreSQL version 9.1 database
What is the process of two-way encryption of data in PostgreSQL database version 9.1 using built-in functions?
5
votes
3answers
1k views
Postgresql row-level encryption
Looking over the docs, I didn't see any mention of row-level encryption.
Lets assume I have a database of highly classified information that needs to get locked down. How can I implement a table with ...
