Feed on
Posts
Comments

Tag Archive 'Postgresql'

Scheduled PostgreSQL Database Backups

Posted in General on Jun 11th, 2009

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.
Usage is [...]

Read Full Post »

Getting Postgresql 8.3.x on Gentoo

Posted in General on Apr 12th, 2009

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 findings [...]

Read Full Post »