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@xxxxxxxxxxxxx>
To: "Chun Yit(Chronos)" <ivanbeh@xxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, May 08, 2006 10:43 PM
Subject: Re: [GENERAL] catalog is missing 16 attribute(s) for relid 8202590
"Chun Yit\(Chronos\)" <ivanbeh@xxxxxxxxxxxxxx> 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
