Re: [HACKERS] Still having trouble importing 6.3 DB

On Mon, 4 Jan 1999, Tom Lane wrote:

> 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.
>

I had this problem ypgrading from 6.4betaX to 6.4{0,1,2}
A quick note , first do a pg_dumpall do dump all your databases the mv
data data.old recreate the data directory and do an initdb that will create
all the relations properly , otherwise the pg_user view is not installed and
you will have some problems!

--
Incredible Networks LTD Angelos Karageorgiou
20 Karea st, +30.1.92.12.312 (voice)
116 36 Athens, Greece. +30.1.92.12.314 (fax)
http://www.incredible.com angelos(at)incredible(dot)com (e-mail)