Difference between revisions of "Upgrade Postgresql to a newer Version"
Jump to navigation
Jump to search
(How to Upgrade Postgresql) |
|||
| Line 2: | Line 2: | ||
* Check that the server is running | * Check that the server is running | ||
* Start the dump | * (If necessary) Start the dump | ||
$ pg_dumpall > db.out | $ pg_dumpall > db.out | ||
* OR move the data directory to a backup location | |||
* Upgrade Postgresql to a newer version via for example Yast | * Upgrade Postgresql to a newer version via for example Yast (pg9 is in repository: Postgresql 9 | ||
<nowiki>URL: http://ftp5.gwdg.de/pub/opensuse/repositories/server:/database:/postgresql/SLE_11_SP1/ </nowiki> | |||
* Start Postgresql server or initalize the new DB and start Postgresql server. | * Start Postgresql server or initalize the new DB and start Postgresql server. | ||
* Import the database | ** Error calling pgping undefined symbol in pg 9.1 - informational only, server still starts | ||
* (If necessary) Import the database | |||
$ psql -f db.out template1 | $ psql -f db.out template1 | ||
* OR | |||
Now Postgresql is running in a newer version with the data of the old version. | Now Postgresql is running in a newer version with the data of the old version. | ||
[[Category:Serveradministration|Upgrade Postgresql to a newer Version]] | [[Category:Serveradministration|Upgrade Postgresql to a newer Version]] | ||
Latest revision as of 13:27, 17 October 2011
How to Upgrade Postgresql[edit]
- Check that the server is running
- (If necessary) Start the dump
$ pg_dumpall > db.out
- OR move the data directory to a backup location
- Upgrade Postgresql to a newer version via for example Yast (pg9 is in repository: Postgresql 9
URL: http://ftp5.gwdg.de/pub/opensuse/repositories/server:/database:/postgresql/SLE_11_SP1/
- Start Postgresql server or initalize the new DB and start Postgresql server.
- Error calling pgping undefined symbol in pg 9.1 - informational only, server still starts
- (If necessary) Import the database
$ psql -f db.out template1
- OR
Now Postgresql is running in a newer version with the data of the old version.