Oh, got it. Thanks.
-Original Message-
From: David Fetter [mailto:[EMAIL PROTECTED]
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
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 <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778
Tom,
I used:
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 dum
