| 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: | 2008-06-30 23:37:29 |
| Message-ID: | 19584.1214869049@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carl-Daniel Hailfinger | 2008-07-01 02:47:45 | BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM |
| Previous Message | Tom Lane | 2008-06-30 23:25:54 | Re: Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held" |