Re: Can not restart postgres: Panic could not locate a valid checkpoint record - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Can not restart postgres: Panic could not locate a valid checkpoint record
Date
Msg-id dcc563d10804221222n258d517ft1ca004526c47317@mail.gmail.com
Whole thread Raw
In response to Re: Can not restart postgres: Panic could not locate a valid checkpoint record  (Mary Ellen Fitzpatrick <mfitzpat@bu.edu>)
List pgsql-general
On Tue, Apr 22, 2008 at 1:00 PM, Mary Ellen Fitzpatrick <mfitzpat@bu.edu> wrote:
> I ran the pg_resetxlog -n to test and it found the correct values.  Ran it
> for real and it worked.

Note that on most unix systems, some percentage of disk storage is
reserved for use by root only.  On linux with ext2/3 you can change
this % with the tune2fs command...

tune2fs -m 0 /dev/sdb2

would set the drive mounted from /dev/sdb2 to have 0 reserved % for
root, and may be enough in the future to get you out of this
situation.  Be sure to set it back to 1 or 2 % after you've cleaned up
enough so you have the free space again when you need it.

The same thing can be done with quotas...

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: table as log (multiple writers and readers)
Next
From: Joris Dobbelsteen
Date:
Subject: Re: table as log (multiple writers and readers)