Thread: Restoring 7.4.2 pg_dumpall output in 8.1.4 fails
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
On Thu, Aug 10, 2006 at 11:44:31AM -0700, Jie Liang wrote: > Tom, > I used: > pg_dumpall > db.out on my 7.4.2 server 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@fetter.org> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
Oh, got it. Thanks. -----Original Message----- From: David Fetter [mailto:david@fetter.org]=20 Sent: Thursday, August 10, 2006 6:31 PM To: Jie Liang Cc: Tom Lane; pgsql-bugs@postgresql.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: > Tom, > I used: > pg_dumpall > db.out on my 7.4.2 server 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@fetter.org> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!