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 ready to run on port 5434 if needed. | + | 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. | See [[Database_Backups]] for information on how we back up postgres. | ||
[[Category:Sysadmin_Documentation]] | [[Category:Sysadmin_Documentation]] | ||
Latest revision as of 07:45, 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. 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.
