Postgres
From UGCS
(Difference between revisions)
(New page: 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 si...) |
|||
| Line 1: | Line 1: | ||
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 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. | See [[Database_Backups]] for information on how we back up postgres. | ||
[[Category:Sysadmin_Documentation]] | [[Category:Sysadmin_Documentation]] | ||
Revision as of 07:41, 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 running on port 5434 in case it is needed.
See Database_Backups for information on how we back up postgres.
