[Pkg-postgresql-public] Bug#688960: postgresql-common - pg_upgradecluster fails with "OLD used in query that is not in a rule"

[Bastian Blank]

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