> 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