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
://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
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
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