DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=N2K4YAHHr1uY3WCwReLGpVg5Dd98+a16SbQ6QXbs4o+311B00u6heb4kSbWlRxRnikd3TOW209QsO/aAcq9puEVdIgY4W9dmyOTbV3WPt3IgyUUdtPvLJKCMuFddJ3NF2CnNXHOlIw/y8PQauNz29/EHKLNnEqyFi2cqkkWT464=;
Date: Mon, 30 Jun 2008 11:11:47 +0000 (GMT)
From: Valentin Bogdanov <valiouk@yahoo.co.uk>
Reply-To: valiouk@yahoo.co.uk
Subject: psql: FATAL:  the database system is starting up
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Message-ID: <160462.73401.qm@web25804.mail.ukl.yahoo.com>

Hi,

I run out of disk space on the box and had to delete some files and restart=
 postgres. Ever since I have been getting the above message. PS shows this =
process:

 9351 ?        D      0:04 postgres: startup process

Running an strace on this process shows that it is trying to write 8K of ze=
ros to a file called 023D in pg_clog but fails at 224K and it just keeps tr=
ying forever.

I tried replacing the file with one I created - 256K as the other files in =
the pg_clog and filled with zeros. But it keeps doing the same thing :

open("pg_clog/023D", O_RDWR|O_CREAT|O_LARGEFILE, 0600) =3D 10
_llseek(10, 221184, [221184], SEEK_SET) =3D 0
write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192=
) =3D 8192
fsync(10)                               =3D 0
close(10)=20


Any ideas on what might be causing this and what I can do to fix it will be=
 greatly appreciated. Need to get it fixed fast.


Many Thanks
valiouk=0A=0A=0A      _____________________________________________________=
_____=0ANot happy with your email address?.=0AGet the one you really want -=
 millions of new email addresses available now at Yahoo! http://uk.docs.yah=
oo.com/ymail/new.html