Re: [HACKERS] Still having trouble importing 6.3 DB

Поиск
Список
Период
Сортировка
От Angelos Karageorgiou
Тема Re: [HACKERS] Still having trouble importing 6.3 DB
Дата
Msg-id Pine.BSI.4.05L.9901051111540.19412-100000@awesome.incredible.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Still having trouble importing 6.3 DB  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Marcus Mascari
Дата:
Сообщение: NaN format
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] MVCC works in serialized mode!