[Pkg-postgresql-public] Bug#714328: Bug#714328: postgresql-9.3: Postinstall script fails

[Martin Pitt]

Hello Diederik,

Diederik de Haas [2013-06-28  1:50 +0200]:
>   [....] Starting PostgreSQL 9.3 database server: main[....] The
>   PostgreSQL server failed to start. Please check the log output:
>   2013-06-28 01:43:16 CEST FATAL: database files are incompatible with
>   server 2013-06-28 01:43:16 CEST DETAIL: The database cluster was
>   initialized with CATALOG_VERSION_NO 201305061, but [FAILerver was
>   compiled with CATALOG_VERSION_NO 201306121.

Ah, sorry about that. The DB format changed between beta1 and beta2,
so this upgrade doesn't work with existing clusters. I'll add some
preinst magic to guard against that.

In the meantime, if you don't need the DB any more, please run

  # pg_dropcluster 9.3 main

(as root), and then re-install/re-upgrade. If you do need it, you need
to downgrade the postgresql-9.3 and postgresql-client-9.3 package
back to 9.3~beta1, dump the DB, and then call pg_dropcluster and
upgrade, and restore it.

Martin
-- 
Martin Pitt                        | http://www.piware.de
Ubuntu Developer (www.ubuntu.com)  | Debian Developer  (www.debian.org)