Postgres
From UGCS
Revision as of 07:41, 28 September 2009 by Jdhutchin@ugcs.caltech.edu (Talk | contribs)
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 running on port 5434 in case it is needed.
See Database_Backups for information on how we back up postgres.
