Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CACD99F93C6 for ; Tue, 30 Oct 2007 13:20:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92313-06 for ; Tue, 30 Oct 2007 13:20:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web37913.mail.mud.yahoo.com (web37913.mail.mud.yahoo.com [209.191.91.175]) by postgresql.org (Postfix) with SMTP id 9F6F29F9491 for ; Tue, 30 Oct 2007 13:20:18 -0300 (ADT) Received: (qmail 9274 invoked by uid 60001); 30 Oct 2007 16:20:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=eStqS+eTMz/tMNPaLMMRLVvVZ4zzfqTRqBtFKus0XnNqtdHjsFmttGQFG5RgXnKiSBYE4/LzZNXpFbWx2EvfjWBnGFyqBd1ktVtSvj+3HYg/GnuViN90KOrZEy8RLRdCr1wsadiIFIsheiYoKbGP/bX75XFULCLJ8L0LDfjl/10=; X-YMail-OSG: cujogtEVM1n.bXWfTpfEXxAuA07CGNN83i2BeR6QrryUwzz0Hep6Kyd.bMiVLD9ZFVGrZFWJYqRmEVI.e1aKxTbtM9PZkKnpMBZjj2AK4AXpfbjVquCfgGGHC82zJg-- Received: from [203.200.31.62] by web37913.mail.mud.yahoo.com via HTTP; Tue, 30 Oct 2007 09:20:13 PDT Date: Tue, 30 Oct 2007 09:20:13 -0700 (PDT) From: karthik keyan Subject: Postgresql Database Corrupted To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-568705224-1193761213=:5883" Content-Transfer-Encoding: 8bit Message-ID: <529419.5883.qm@web37913.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200710/306 X-Sequence-Number: 27220 --0-568705224-1193761213=:5883 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi admins I have a issue with my database . Its not starting up after /var got filled up After clearing some space still the database doesnt start up .. Pls find the log vacuumdb: vacuuming of database "insight_v1_0" failed: ERROR: could not access status of transaction 124321809 DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/0076" at offset 147456: Success __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-568705224-1193761213=:5883 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi admins
 
I have a issue with my database .
 
Its not starting up after /var got filled up
 
After clearing some space still the database doesnt start up ..
 
Pls find the log vacuumdb: vacuuming of database "insight_v1_0" failed: ERROR:  could not access status of transaction 124321809
DETAIL:  could not read from file "/var/lib/pgsql/data/pg_clog/0076" at offset 147456: Success
 
 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-568705224-1193761213=:5883--