Upgrade Postgresql to a newer Version

=How to Upgrade Postgresql=


 * Check that the server is running
 * (If necessary) Start the dump

$ pg_dumpall > db.out URL: http://ftp5.gwdg.de/pub/opensuse/repositories/server:/database:/postgresql/SLE_11_SP1/
 * 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
 * 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

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