Upgrade Postgresql to a newer Version

From MPDLMediaWiki

Revision as of 09:16, 25 February 2011 by Knoth (talk | contribs) (How to Upgrade Postgresql)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

How to Upgrade Postgresql

Check that the server is running
Start the dump

$ pg_dumpall > db.out

Upgrade Postgresql to a newer version via for example Yast
Start Postgresql server or initalize the new DB and start Postgresql server.
Import the database

$ psql -f db.out template1

Now Postgresql is running in a newer version with the data of the old version.

Retrieved from "https://colab.mpdl.mpg.de/mw010/index.php?title=Upgrade_Postgresql_to_a_newer_Version&oldid=59934"

Serveradministration