On Thu, 2012-09-27 at 15:58 +0200, Bastian Blank wrote: > 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 > | #
It is correct to use the pg_dumpall from 9.1 when upgrading from 8.4 to 9.1 What you see here is possibly an upstream bug in 9.1's pg_dump(all). Please send a reproducible test case to pgsql-b...@postgresql.org (e.g., execute this in 8.4 server, dump it with 9.1 pg_dump, doesn't reload into 9.1 server). -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
