From: | GB Clark II <postgres(at)vsservices(dot)com> |
---|---|
To: | "Nick Fankhauser" <nickf(at)doxpop(dot)com>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Can't get postmaster to restart after removing WAL files |
Date: | 2001-09-15 13:04:34 |
Message-ID: | 0109150804340G.73075@prime.vsservices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tuesday 11 September 2001 06:04, Nick Fankhauser wrote:
> 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,
I got bit by the same thing!
Take a look in the contrib directory for pg_resetxlog. Thats what saved me...
GB
--
GB Clark II | Roaming FreeBSD Admin
gclarkii(at)VSServices(dot)COM | General Geek
CTHULU for President - Why choose the lesser of two evils?
From | Date | Subject | |
---|---|---|---|
Next Message | Haroldo Stenger | 2001-09-15 17:23:15 | Re: Transaction Aborting on sql call failure |
Previous Message | Kevin McFadden | 2001-09-14 20:22:31 | Re: FINAL: Multi-User PostgreSQL usage SECURITY |