Re: psql: FATAL: the database system is starting up - Mailing list pgsql-bugs

From Tom Lane
Subject Re: psql: FATAL: the database system is starting up
Date
Msg-id 19584.1214869049@sss.pgh.pa.us
Whole thread Raw
In response to psql: FATAL: the database system is starting up  (Valentin Bogdanov <valiouk@yahoo.co.uk>)
List pgsql-bugs
Valentin Bogdanov <valiouk@yahoo.co.uk> writes:
> I run out of disk space on the box and had to delete some files and restart postgres. Ever since I have been getting
theabove 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
failsat 224K and it just keeps trying forever. 

What PG version is this, exactly?  What files did you delete (any of
Postgres' files)?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"
Next
From: "Carl-Daniel Hailfinger"
Date:
Subject: BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM