Re: catalog is missing 16 attribute(s) for relid 8202590 - Mailing list pgsql-general

From Chun Yit\(Chronos\)
Subject Re: catalog is missing 16 attribute(s) for relid 8202590
Date
Msg-id 000901c6734c$daf054d0$a279640a@Beh
Whole thread Raw
In response to catalog is missing 16 attribute(s) for relid 8202590  ("Chun Yit\(Chronos\)" <ivanbeh@chronos.com.my>)
List 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 by date:

Previous
From: Hannes Dorbath
Date:
Subject: Arguments Pro/Contra Software Raid
Next
From: João Miguel Ferreira
Date:
Subject: Re: database size grows (even after vacuum (full and analyze))....