Postgres
From UGCS
(Difference between revisions)
| Line 2: | Line 2: | ||
| − | 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 | + | 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. |
See [[Database_Backups]] for information on how we back up postgres. | See [[Database_Backups]] for information on how we back up postgres. | ||
[[Category:Sysadmin_Documentation]] | [[Category:Sysadmin_Documentation]] | ||
Revision as of 07:42, 28 September 2009
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.
See Database_Backups for information on how we back up postgres.
