From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Can't get postmaster to restart after removing WAL files |
Date: | 2001-09-11 11:16:30 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGIEGJDKAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all-
I caused a crash by filling up the filesystem that pg_xlog lives on whilst
doing a vacuum analyze. When I looked at the remains, there were 3 WAL files
out there & no space left.
I tried simply restarting (/etc/init.d/postgresql start) in the hopes that
the mess would get cleaned, but with no luck. The startup script reported
success, but no postmaster was running.
I tried removing the WAL files & restarting again with the same results- the
startup script reports success, but postmaster isn't running.
I'm not worried about the data- this is on a demo system, so I can
regenerate it quickly, but I can't even get the postmaster started so I can
begin the restore. I guess I've learned that removing a WAL file is a Bad
Idea (tm)... but now I need a good idea to get me back to the starting
point.
Any ideas?
TIA-
-Nick
---------------------------------------------------------------------
Nick Fankhauser
nickf(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Randy Hall | 2001-09-11 11:26:34 | Re: Can't get postmaster to restart after removing WAL files |
Previous Message | Nick Fankhauser | 2001-09-11 11:04:47 | Can't get postmaster to restart after removing WAL files |