Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: psql: FATAL: the database system is starting up
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: valiouk(at)yahoo(dot)co(dot)uk
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: psql: FATAL: the database system is starting up
- Date: Mon, 30 Jun 2008 19:37:29 -0400
- Message-id: <19584.1214869049@sss.pgh.pa.us> <text/plain>
Valentin Bogdanov <valiouk(at)yahoo(dot)co(dot)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 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. What PG version is this, exactly? What files did you delete (any of Postgres' files)? regards, tom lane
- References:
- psql: FATAL: the database system is starting up
- From: Valentin Bogdanov
- psql: FATAL: the database system is starting up
- Prev by Date: Re: Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"
- Previous by thread: psql: FATAL: the database system is starting up
- Next by thread: Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"
- Indexes: