Re: [HACKERS] Still having trouble importing 6.3 DB

> Ah, I see what's going on.  You're getting burnt by not having upgraded
> to 6.3.1 or 6.3.2 before moving to 6.4.  The pg_user table was changed
> at 6.3.1, and pg_dumpall was modified accordingly --- but the 6.3
> version of pg_dumpall produces a script that will not successfully load
> the user definitions into 6.3.1 or later.

Ooh, good catch.  You are correct.

> 
> I think you can make it work by just changing "copy pg_user from stdin;"
> to "copy pg_shadow from stdin;" a couple lines down from the top of
> the dump script.
> 
> Memo to hackers: we need a better way of coping with cross-version
> changes that affect dump scripts...

Not sure how to deal with that one.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026