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

Shai Berger shai at platonix.com
Thu Oct 16 11:17:57 UTC 2014

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 /var/log/postgresql/postgresql-9.3-main.log
9.4 main    5433 online postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log

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

More information about the Pkg-postgresql-public mailing list