Re: [HACKERS] Still having trouble importing 6.3 DB - Mailing list pgsql-hackers

From Angelos Karageorgiou
Subject Re: [HACKERS] Still having trouble importing 6.3 DB
Date
Msg-id Pine.BSI.4.05L.9901051111540.19412-100000@awesome.incredible.com
Whole thread Raw
In response to Re: [HACKERS] Still having trouble importing 6.3 DB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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@incredible.com (e-mail)



pgsql-hackers by date:

Previous
From: Marcus Mascari
Date:
Subject: NaN format
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] MVCC works in serialized mode!