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