nickhowell.co.uk

I’ve just started using PostgreSQL as my database of choice for a few projects, and needed some way of scheduling backups. As a result I’ve created the following small bash script that will backup a given database and put it in a gzipped tar archive. You can find the script in my svn repository here. [...]

Tags: backups, Linux, Postgresql

I recently had some fun and games upgrading PostgresSQL on my Gentoo box – I was running 8.2.7 and needed 8.3.x for it’s support of ENUM types. After some googling I found this blog which explained how to do it. There were a few extra steps for me, however, so I though I’d repost my [...]

Tags: Gentoo, Linux, Postgresql