[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 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

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

://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] PITR for postgresql-7.3

, Mary Ellen Fitzpatrick [EMAIL PROTECTED] wrote: Hi, We are running postgresql-7.3.3 and we had a hardware controller and disk failure on the system. And of course the database does not appear to be backup anywhere. Ouch, I feel your pain. I was reading about PITR and was wondering

[GENERAL] PITR for postgresql-7.3

Hi, We are running postgresql-7.3.3 and we had a hardware controller and disk failure on the system. And of course the database does not appear to be backup anywhere. I was reading about PITR and was wondering if that is applicable to my version. We do have pg_xlog files and I am