clog problem - Mailing list pgsql-general

From Bob Parkinson
Subject clog problem
Date
Msg-id Pine.BSF.4.44.0209041113160.28255-100000@gw7200.nottingham.ac.uk
Whole thread Raw
In response to Re: help please  (frbn <frbn@efbs-seafrigo.fr>)
Responses Re: clog problem + version info  (Bob Parkinson <rwp@biome.ac.uk>)
Re: clog problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I've got this:

FATAL 2:  open of /usr/local/pgsql/data/pg_clog/02B6 failed: No such file
or directory
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
connection to server was lost

This was when the nightly vacuum was running.

I had this problem a few weeks ago and had to restore from a backup. Whats
is causing this? I've seen some refs. to clog problems relating to
7.2.beta somethin, but not found any resoloution.

Cheers,

Bob

Bob Parkinson
rwp@biome.ac.uk
------------------------------------------------------------------
Technical Manager:         Biome             http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham.                          0115 9249924 x 42059
------------------------------------------------------------------
                        We are stardust


pgsql-general by date:

Previous
From: frbn
Date:
Subject: Re: help please
Next
From: Oliver Elphick
Date:
Subject: Re: Screwy behavior with SUM and multiple joins to same