Обсуждение: failure on updating database from 7.1 to 7.3

hello,

after compiling and installing postgresql 7.3 i tried to dump the old
database of the running 7.1-server with "pg_dumpall -o > test" of the
new version like recommendend by the "INSTALL"-file.

it answered:
bash$ /usr/local/pgsql-7.3/bin/pg_dumpall -o > test
pg_dump: column number -1 is out of range 0..4
pg_dumpall: pg_dump failed on adressen, exiting

then i tried the old version of pg_dumpall. this worked and i could
restore the database to a new database version 7.3.

but when i try to backup databases with pg_dump the failure is the same
as known from pg_dumpall and the old database.

can anyone help me?

bye
arnie

Arne Roolfs <roolfs@novacard.de> writes:
> after compiling and installing postgresql 7.3 i tried to dump the old
> database of the running 7.1-server with "pg_dumpall -o > test" of the
> new version like recommendend by the "INSTALL"-file.

> it answered:
> bash$ /usr/local/pgsql-7.3/bin/pg_dumpall -o > test
> pg_dump: column number -1 is out of range 0..4
> pg_dumpall: pg_dump failed on adressen, exiting

Yeah, the 7.3 version of pg_dump is broken for 7.1 servers :-(.  This is
fixed for 7.3.1.  I believe I posted the patch on one of the mailing
lists last week, or you can get it from CVS.

            regards, tom lane