From: Valentin Bogdanov <valiouk@yahoo.co.uk>
To: pgsql-admin@postgresql.org
Subject: psql: FATAL: the database system is starting up
Date: Mon, 30 Jun 2008 11:11:47 +0000 (GMT)
Message-ID: <160462.73401.qm@web25804.mail.ukl.yahoo.com> (raw)
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 zeros to a file called 023D in pg_clog but fails at 224K and it just keeps trying 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) = 10
_llseek(10, 221184, [221184], SEEK_SET) = 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) = 8192
fsync(10) = 0
close(10)
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
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: valiouk@yahoo.co.uk
Subject: Re: psql: FATAL: the database system is starting up
In-Reply-To: <160462.73401.qm@web25804.mail.ukl.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox