Tom,
I used:=20
pg_dumpall > db.out on my 7.4.2 server
Then, I use: psql -f db.out postgres on my 8.1.4 server.
I got chunk of:
1232133 invalid command \N
1232134 invalid command \N
I found that come from my inheritant table, the pg_dump(all) didn't make
right order on parent and child tables, it dumped child tables first
then parent table, so I restore them, it try to create child table first
which will fail definitely then all the data try to be loaded later on
will be errored out. I am not sure 8.1.4's pg_dump(all) fixed this bug
or not. Currently, I think I can work around it by editing the order on
archive.list file and use pg_restore.


Best Regards,


Jie Liang

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Thu, Aug 10, 2006 at 11:44:31AM -0700, Jie Liang wrote:
It's not a bug. Use the pg_dumpall from 8.1.4 to talk to the
still-live 7.4.2 server

Cheers,
D
--
David Fetter <david (AT) fetter (DOT) org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Oh, got it. Thanks.

-----Original Message-----
From: David Fetter [mailto:david (AT) fetter (DOT) org]=20
Sent: Thursday, August 10, 2006 6:31 PM
To: Jie Liang
Cc: Tom Lane; pgsql-bugs (AT) postgresql (DOT) org
Subject: Re: [BUGS] Restoring 7.4.2 pg_dumpall output in 8.1.4 fails


On Thu, Aug 10, 2006 at 11:44:31AM -0700, Jie Liang wrote:
It's not a bug. Use the pg_dumpall from 8.1.4 to talk to the still-live
7.4.2 server

Cheers,
D
--=20
David Fetter <david (AT) fetter (DOT) org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster