[Pkg-postgresql-public] Bug#764705: Bug#764705: postgresql-9.4: ERROR: The database format changed between beta 2 and 3. Please dump, but how?

Christoph Berg cb at df7cb.de
Thu Oct 16 18:13:42 UTC 2014

On 16. Oktober 2014 13:17:57 MESZ, Shai Berger <shai at platonix.com> wrote:
>Package: postgresql-9.4
>Followup-For: Bug #764705
>Dear Maintainer,
>I, like a previous poster, have this:
>postgres at deblack:~$ pg_lsclusters
>Ver Cluster Port Status Owner    Data directory               Log file
>9.3 main    5432 online postgres /var/lib/postgresql/9.3/main
>9.4 main    5433 online postgres /var/lib/postgresql/9.4/main
>which means I have both 9.3 and 9.4 installed. Thus, I was a little
>worried about the command 
>	$ zcat 9.4-main.dump.gz | psql -q
>in the instructions -- there was no mention of 9.4 in the dump file,
>and by default, psql connects to the 9.3 server; thus, I think that
>if I had run the command as given, it would have applied to the 9.3
>cluster and not the 9.4 one.
>I ran it instead as 
>	$ zcat 9.4-main.dump.gz | psql -p5433
>(9.3 runs on 5432, 9.4 on 5433). If I'm wrong, I'd love to be told
>about it; otherwise, I suspect the instructions should be modified.
>-- System Information:
>Debian Release: jessie/sid
>  APT prefers unstable
>  APT policy: (500, 'unstable'), (500, 'testing')
>Architecture: amd64 (x86_64)
>Kernel: Linux 3.16-2-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.4 depends on:
>ii  libc6                  2.19-11
>ii  libgssapi-krb5-2       1.12.1+dfsg-10
>ii  libldap-2.4-2          2.4.39-1.1+b1
>ii  libpam0g               1.1.8-3.1
>ii  libpq5                 9.4~beta3-2
>ii  libssl1.0.0            1.0.1j-1
>ii  libxml2                2.9.1+dfsg1-4
>ii  locales                2.19-11
>ii  postgresql-client-9.4  9.4~beta3-2
>ii  postgresql-common      162
>ii  ssl-cert               1.0.35
>ii  tzdata                 2014h-2
>postgresql-9.4 recommends no packages.
>Versions of packages postgresql-9.4 suggests:
>pn  locales-all             <none>
>pn  oidentd | ident-server  <none>
>-- no debconf information
>Pkg-postgresql-public mailing list
>Pkg-postgresql-public at lists.alioth.debian.org

Right, the correct psql call needs --cluster 9.4/main appended. Not sure if this warrants another upload, though.

More information about the Pkg-postgresql-public mailing list