Hot answers tagged postgresql
Use gpg (GnuPG). You'll be able to generate multiple keys and encrypt a file for decryption with any key from chosen list. Also GPG keys are not symmetric — your server only need public keys for encryption. Private keys, used for decryption, might be securely stored somewhere else. You can for example print one private key as QRcode for your director and ...
Generally it is not a smart idea. See, databases are written by smart people and use as much memory for caching as possible. If you hit the disc too often, then you have a memory problem - and keeping ANOTHER copy in the same limited memory will not make things better. What someone should do is baseline analysis. What is the bottleneck? Fix it. More memory, ...
Sounds like a permissions issue on /tmp/.s.PGSQL.6434 if it occurs on restart. Make sure you're restarting as the same user or su - pgbounceruser -c "/usr/bin/pgbouncer -R -d /etc/pgbouncer/pgbouncer.ini" to have it take new settings.
The scheme that is implemented in at least one commercial DBMS that I know uses two keys, let's call them the master key and the database key. The master key is used to encrypt the database key. The database key, which could be of a higher grade, is used to encrypt and decrypt the backup images. The master key can be safely rotated, because it only ...
I had the same issue earlier. Upon checking the log, I saw that postgres was complaining about diskspace. A df -h showed that the device had 0MB free space available. After freeing up some space, it worked.
Only top voted, non community-wiki answers of a minimum length are eligible