| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Mary Ellen Fitzpatrick" <mfitzpat(at)bu(dot)edu> |
| Cc: | "BRUSSER Michael" <Michael(dot)BRUSSER(at)3ds(dot)com>, "PGSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can not restart postgres: Panic could not locate a valid checkpoint record |
| Date: | 2008-04-22 19:22:11 |
| Message-ID: | dcc563d10804221222n258d517ft1ca004526c47317@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 22, 2008 at 1:00 PM, Mary Ellen Fitzpatrick <mfitzpat(at)bu(dot)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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joris Dobbelsteen | 2008-04-22 19:42:32 | Re: table as log (multiple writers and readers) |
| Previous Message | Gurjeet Singh | 2008-04-22 19:17:13 | Re: table as log (multiple writers and readers) |