Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4QEs9A68723 for ; Sat, 26 May 2001 10:54:09 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4QErvR22397; Sat, 26 May 2001 10:53:57 -0400 (EDT) To: "J.Fernando Moyano" cc: pgsql-sql@postgresql.org Subject: Re: corrupted tables !!! In-reply-to: <01052610432703.01848@txino.mikasa.eh> References: <01052610432703.01848@txino.mikasa.eh> Comments: In-reply-to "J.Fernando Moyano" message dated "Sat, 26 May 2001 10:43:27 -0400" Date: Sat, 26 May 2001 10:53:56 -0400 Message-ID: <22394.990888836@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/282 X-Sequence-Number: 3110 "J.Fernando Moyano" writes: > I have big problems with my postgres. > There is a table that gets corrupted frecuently !!! (every week ...) This isn't much information. What version of Postgres are you running? (If your answer isn't "7.0.3" or "7.1.2", the first thing I'm going to tell you to do is upgrade.) What sort of corruption are you seeing --- I want exact details, not hypotheses about what's causing it. Are there any unexpected messages in the postmaster log? Do you see any server crashes (backend coredumps), and if so can you provide a debugger backtrace from the core file? regards, tom lane