Month: December 2009

To upgrade a PostgreSQL installation start by dumping all the existing databases. You should do this before stopping the current database server$ PGUSER=postgres /usr/bin/pg_dumpall > dump.sql
$ sudo /etc/init/d/postgresql stop
$ sudo mv /usr/local/pgsql /usr/local/pgsql.old