Bash script for emergency stop of PostgreSQL

PostgreSQL has one serious weakness – it crashes when some of filesystems it uses if full. Plus PostgreSQL is unable to check if such problem is comming. It simply crashes with error like this: PANIC: could not write to file "pg_xlog/xlogtemp.1752": No space...

SQL injection in PostgreSQL

There are already some very good texts about it on web and I do not want to “steal” credit from them: Detecting PostgreSQL SQL injection Postgres SQL injection cheat sheet There are just some of my experiencies: If you can use prepared statements instead...