Bug#714328: postgresql-9.3: Postinstall script fails

2013-06-27 Thread Diederik de Haas
Package: postgresql-9.3
Version: 9.3~beta2-1
Severity: important

Dear Maintainer,

While running aptitude safe-upgrade, the post-install scripts fails:
The following partially installed packages will be configured:
  postgresql-9.3 
  No packages will be installed, upgraded, or removed.
  0 packages upgraded, 0 newly installed, 0 to remove and 0 not
  upgraded.
  Need to get 0 B of archives. After unpacking 0 B will be used.
  Setting up postgresql-9.3 (9.3~beta2-1) ...
  [] 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. 2013-06-28 01:43:16 CEST
  HINT: It looks like you need to initdb. ... failed!
  failed!
  invoke-rc.d: initscript postgresql, action start failed.
  dpkg: error processing postgresql-9.3 (--configure):
  subprocess installed post-installation script returned error exit
  status 1
  Errors were encountered while processing:
  postgresql-9.3
  E: Sub-process /usr/bin/dpkg returned an error code (1)
  A package failed to install.  Trying to recover:
  Setting up postgresql-9.3 (9.3~beta2-1) ...
  [] Starting PostgreSQL 9.3 database server: main[] The
  PostgreSQL server failed to start. Please check the log output:
  2013-06-28 01:43:18 CEST FATAL: database files are incompatible
  with server 2013-06-28 01:43:18 CEST DETAIL: The database cluster
  was initialized with CATALOG_VERSION_NO 201305061, but [FAILerver
  was compiled with CATALOG_VERSION_NO 201306121. 2013-06-28 01:43:18
  CEST HINT: It looks like you need to initdb. ... failed!
  failed!
  invoke-rc.d: initscript postgresql, action start failed.
  dpkg: error processing postgresql-9.3 (--configure):
  subprocess installed post-installation script returned error exit
  status 1
  Errors were encountered while processing:
  postgresql-9.3

Note that I've recently install postgresql for the first time and I've
only created 1 db to 'play'. 
If I need to do 'things' with postgresql to provide additional
information, you'll likely have to tell me how to do it.
I am familiar with (adminstrating) Debian though.

Cheers,
  Diederik

-- System Information:
Debian Release: jessie/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing'), (101, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.9-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-9.3 depends on:
ii  libc6  2.17-5
ii  libcomerr2 1.42.8-1
ii  libgssapi-krb5-2   1.10.1+dfsg-6
ii  libkrb5-3  1.10.1+dfsg-6
ii  libldap-2.4-2  2.4.31-1+nmu2
ii  libpam0g   1.1.3-9
ii  libpq5 9.3~beta2-1
ii  libssl1.0.01.0.1e-3
ii  libxml22.9.1+dfsg1-2
ii  locales2.17-5
ii  postgresql-client-9.3  9.3~beta2-1
ii  postgresql-common  145
ii  ssl-cert   1.0.32
ii  tzdata 2013c-2

postgresql-9.3 recommends no packages.

Versions of packages postgresql-9.3 suggests:
pn  locales-all none
pn  oidentd | ident-server  none

-- no debconf information


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



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

2013-06-27 Thread 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)


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



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

2013-06-27 Thread Diederik de Haas


Martin Pitt mp...@debian.org wrote:
Hello Diederik,

Hi Martin,

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.

No problem and excellent.

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

  # pg_dropcluster 9.3 main

Did that, upgraded, ran '#pg_createcluster 9.3 main' and 
'#/etc/init.d/postgresql start' 
(it didn't start after the upgrade, normal?) and I was up and running again :-)

Cheers!
   Diederik


--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org