Hi,
We have web application and encrypt PII columns. We use encrypt/decrypt
function for this.
Currently we hard coded the key in postgresql function which I am not
sure of it.
I did google it and people suggest that it needed to be stored in
physically isolated location (storing decryption key on the same server
as the data is kind of like writing your PIN on your ATM card).
I would like to know how postgres professionals handles this.
Thank you very much for your time in advance.
Naoko