Re: [GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record

2008-04-22 Thread Scott Marlowe
On Tue, Apr 22, 2008 at 1:00 PM, Mary Ellen Fitzpatrick <[EMAIL PROTECTED]> 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 wit

Re: [GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record

2008-04-22 Thread Mary Ellen Fitzpatrick
://www.postgresql.org/docs/8.3/static/app-pgresetxlog.html Michael. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mary Ellen Fitzpatrick Sent: Tuesday, April 22, 2008 1:14 PM To: PGSQL General Subject: [GENERAL] Can not restart postgres: Panic could not locate

Re: [GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record

2008-04-22 Thread BRUSSER Michael
Fitzpatrick Sent: Tuesday, April 22, 2008 1:14 PM To: PGSQL General Subject: [GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record Hi, I am running postgres-8.1 on a Centos5 system. this morning when I came in there was no more disk space on the partition that holds

[GENERAL] Can not restart postgres: Panic could not locate a valid checkpoint record

2008-04-22 Thread Mary Ellen Fitzpatrick
Hi, I am running postgres-8.1 on a Centos5 system. this morning when I came in there was no more disk space on the partition that holds pgsql: /var/lib/pgsql. I believe postgres had crashed at this point. I stupidly removed all of the files under pg_xlog to create disk space. Not knowing that