Thread: 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