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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026