ERROR: The database format changed between beta 2 and 3

October 12, 2014 - Aiko Barz   Linux

PostgreSQL Update unter Debian/SID:

$ aptitude upgrade
[...]
ERROR: The database format changed between beta 2 and 3. Please dump your 9.4 clusters first and remove them before upgrading the package.
[...]

Wie? Keine Ahnung. Trial&Error:

$ su - postgres
$ pg_dumpall > backup_today.sql # User/DB access
$ pg_dropcluster --stop 9.4 main
$ exit

$ aptitude upgrade

$ su - postgres
$ pg_createcluster --locale en_US.UTF-8 9.4 main
$ exit

$ /etc/init.d/postgresql start

$ su - postgres
$ psql -f backup_today.sql postgres # User/DB access
$ exit

(Beim nächsten Mal vorher noch /etc/postgresql sichern…)