[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.
Thanks,
Shai.
-- 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