Postgres

We run Postgresql 8.3 on poseidon. By default, users do not get a database, but they can have one created automatically (remctl poseidon postgres createdb). Since the minimum database size for postgres appears to be 4mb on disk, it would be 7+gb if every user had one.

We migrated from 8.2 to 8.3 on September 27, 2009. We currently have 8.3 running on the main port (5432), and 8.2 ready to run on port 5434 if needed. To start it with an init script, you will have to change "manual" to "auto" in /etc/postgresql/8.2/main/start.conf

See Database_Backups for information on how we back up postgres.