TheRegister is running an article about someone breaking into a dbase, taking control of the encryption key, and 6 or so months later demanding ransom from the owner of the dbase.
Anyone want to comment on this? In general, or PostgreSQL in particular?
As far as I can tell from that article they never broke into any database. They broke into the PHP server, using bugs in PHPBB and injected encryption code in the PHP application so that all data was encrypted *before* it was sent to the database. The database itself was not compromised, it just stored the encrypted texts as the application asked it to.
This would obviously break things as simple as a LIKE matching on a string, but if the application is trivial enough not to use that, it's certainly doable. But all the security issues are 100% within the application itself.