Re: clog problem + version info - Mailing list pgsql-general

From Bob Parkinson
Subject Re: clog problem + version info
Date
Msg-id Pine.BSF.4.44.0209041133200.28255-100000@gw7200.nottingham.ac.uk
Whole thread Raw
In response to clog problem  (Bob Parkinson <rwp@biome.ac.uk>)
List pgsql-general
Doh, postgres-7.2.1 on freebsd4.3

On Wed, 4 Sep 2002, Bob Parkinson wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

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: Oliver Elphick
Date:
Subject: Re: Screwy behavior with SUM and multiple joins to same
Next
From: Oliver Elphick
Date:
Subject: Re: Screwy behavior with SUM and multiple joins to same