Ask HN: Two specific Postgres encrypt questions

scrubs1 pts0 comments

HN,(A) What are the recommended ways to encode Postrgres data at rest (tables+indexes+rows)? The Postgres documentation suggests options [0], but I have no familiarity with any. I prefer to not purchase something.(B) When configuring Postgres with TLS/SSL, one needs to make private keys [1] which can lead to a prompt for a PEM pass phrase. Once all done with Postgres running, do I need to retain the PEM passkey? (The private key itself needs to be retained, of course).[0] https://www.postgresql.org/docs/18/encryption-options.html[1] openssl genrsa -aes256 -out file Enter PEM pass phrase: ...

postgres options needs private pass phrase

Related Articles