Package: postgresql-common Version: 134 Severity: grave pg_upgradecluster from 8.4 to 9.1 fails: | # pg_upgradecluster 8.4 main /srv/postgresql/9.1/main | Stopping old cluster... | Disabling connections to the old cluster during upgrade... | Restarting old cluster with restricted connections... | Creating new cluster (configuration: /etc/postgresql/9.1/main, data: /srv/postgresql/9.1/main)... | Moving configuration file /srv/postgresql/9.1/main/postgresql.conf to /etc/postgresql/9.1/main... | Moving configuration file /srv/postgresql/9.1/main/pg_hba.conf to /etc/postgresql/9.1/main... | Moving configuration file /srv/postgresql/9.1/main/pg_ident.conf to /etc/postgresql/9.1/main... | Configuring postgresql.conf to use port 5433... | Disabling connections to the new cluster during upgrade... | Roles, databases, schemas, ACLs... | pg_dump: SQL command failed | pg_dump: Error message from server: ERROR: OLD used in query that is not in a rule | LINE 1: LOCK TABLE old.eintraege IN ACCESS SHARE MODE | ^ | pg_dump: The command was: LOCK TABLE old.eintraege IN ACCESS SHARE MODE | pg_dumpall: pg_dump failed on database "jsopac", exiting | Re-enabling connections to the old cluster... | Re-enabling connections to the new cluster... | Error during cluster dumping, removing new cluster
Reason is the use of the pg_dumpall from 9.1, which does not work with the 8.4 server: | # sudo -u postgres /usr/lib/postgresql/9.1/bin/pg_dumpall -s > out | pg_dump: SQL command failed | pg_dump: Error message from server: ERROR: OLD used in query that is not in a rule | LINE 1: LOCK TABLE old.eintraege IN ACCESS SHARE MODE | ^ | pg_dump: The command was: LOCK TABLE old.eintraege IN ACCESS SHARE MODE | pg_dumpall: pg_dump failed on database "jsopac", exiting | # sudo -u postgres /usr/lib/postgresql/8.4/bin/pg_dumpall -s > out | # Bastian -- System Information: Debian Release: wheezy/sid APT prefers stable APT policy: (990, 'stable'), (500, 'stable-updates'), (500, 'testing'), (400, 'unstable') Architecture: amd64 (x86_64) Kernel: Linux 3.2.0-3-amd64 (SMP w/1 CPU core) Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
