Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DCA049FD01D for ; Wed, 31 Oct 2007 13:00:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 30187-04 for ; Wed, 31 Oct 2007 12:59:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 9D0489FC73F for ; Wed, 31 Oct 2007 12:07:17 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so315626ugf for ; Wed, 31 Oct 2007 08:07:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=sBXqLceGG7aNDsDjUYYQp4KObPrvH6y8ai2GQASnocM=; b=mB/4QRDp+PZiX/zkArqUoa3FVz7XjAFBHC2t11nHoYOtkoV0IGsRXUsb/EkAAVhvniry8tXI8nbHpwaR5jUuPVVyMQCbr8DIM4DISJdT/VXwN4aJHyzDMSB3eGtZnR+QHYVEN1CI/Qr/wdChal8hHGrQ4VQBck3bvDIt6wG4MSs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=pLmb7ZlNG9+XoLPuQVtUgs2Ba0QOvh15sdYMIXA9qNapQhmMtZqVMuLzIiryg1vbPTz4f0dTdLpQktj+Iyn+VLnVlpibJPwuqrPmlaGp8yuxvBxvKz+hUanU5Molv6ylytOs/rgOqDNP/NbGVc/C7dIPsAINyPXVNs33C10NzVg= Received: by 10.66.222.9 with SMTP id u9mr1632754ugg.1193843236931; Wed, 31 Oct 2007 08:07:16 -0700 (PDT) Received: by 10.67.40.10 with HTTP; Wed, 31 Oct 2007 08:07:16 -0700 (PDT) Message-ID: Date: Wed, 31 Oct 2007 10:07:16 -0500 From: "Scott Marlowe" To: "karthik keyan" Subject: Re: Postgresql Database Corrupted Cc: pgsql-admin@postgresql.org In-Reply-To: <529419.5883.qm@web37913.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <529419.5883.qm@web37913.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/316 X-Sequence-Number: 27230 On 10/30/07, karthik keyan wrote: > 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 So, how did you clear some space? Did that involve deleting the file listed above? If not, you might be able to recreate the pg_clog/0076 file as a file filled with zeroes to get it back up, but who knows what data you might be missing.