Re: catalog is missing 16 attribute(s) for relid 8202590
От | Chun Yit\(Chronos\) |
---|---|
Тема | Re: catalog is missing 16 attribute(s) for relid 8202590 |
Дата | |
Msg-id | 000901c6734c$daf054d0$a279640a@Beh обсуждение исходный текст |
Ответ на | catalog is missing 16 attribute(s) for relid 8202590 ("Chun Yit\(Chronos\)" <ivanbeh@chronos.com.my>) |
Список | pgsql-general |
> i think i make a big misstake by using kill -9 the postmaster .so ,what > should i do when i facing this problem, can someone give advise, cause i > quite new to postgresql. > > how to check there is corrupted data in my database? > > it there anyway i can do to prevent this error msg come back > again? > > cause it just temporary table, can i just remove from database? Regards Beh ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Chun Yit(Chronos)" <ivanbeh@chronos.com.my> Cc: <pgsql-general@postgresql.org> Sent: Monday, May 08, 2006 10:43 PM Subject: Re: [GENERAL] catalog is missing 16 attribute(s) for relid 8202590 > "Chun Yit\(Chronos\)" <ivanbeh@chronos.com.my> writes: >> what i did is i=20 >> 1) kill -9 (postmaster process id). >> 2) remove the postmaster.pid file under /usr/local/pgsql/data/ >> 3) restart the postmaster process. > > The *first* thing you ought to do is learn not to do that. You > deliberately broke the safety interlocks that keep two separate sets of > backends from being active in a single database. If there's corrupted > data in there now, I think it's your own fault. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >
В списке pgsql-general по дате отправления: