[GENERAL] Is there something special to do to pull 6.1 db.out files into 6.4.1 ?

1998-12-27 Thread Robert Chalmers
Hi, well, finally have it all running together, but can't get my old 6.1 data into 6.4.1 now. I did a pg_dumpall -z > db.out in 6.1 and its created the file with all the data in it, but the appropriate psql -e template1 < db.out falls over. Massive error messages, although it actually creates th

[GENERAL] Found solution to reloading dumped 6.1 -> 6.4

1998-12-27 Thread Robert Chalmers
The 6.1 db.out has a line in it that looks like this; CREATE TABLE categories (category varchar(30)) archive = none; If I remove the " archive = none" bit, then all works ok. Excellent. bob -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au

Re: [GENERAL] Found solution to reloading dumped 6.1 -> 6.4

1998-12-27 Thread Bruce Momjian
> The 6.1 db.out has a line in it that looks like this; > > CREATE TABLE categories (category varchar(30)) archive = none; > > If I remove the " archive = none" bit, then all works ok. Excellent. Yes. Archive has been a noise word since Berkeley, and I removed the code to handle it several r