Skip site navigation (1) Skip section navigation (2)

psql: FATAL: the database system is starting up

From: Valentin Bogdanov <valiouk(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: psql: FATAL: the database system is starting up
Date: 2008-06-30 11:11:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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

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

Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo!

pgsql-admin by date

Next:From: Thomas BräutigamDate: 2008-06-30 12:30:23
Subject: Recommended RAID for Postgres
Previous:From: kartikDate: 2008-06-30 09:55:45
Subject: Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group