problem with maintenance script and missing pg_clog files with pg 7.2.1

From: Ben Roberts <benroberts(at)runtime-collective(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: ticket-5082(at)runtime-collective(dot)com
Subject: problem with maintenance script and missing pg_clog files with pg 7.2.1
Date: 2002-09-24 14:49:48
Message-ID: 20020924144948.GG11482@runtime-collective.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are having problems with an installation of Postgres 7.2.1 on Debian
Linux 3.0 (woody).

The scheduled maintenance script throws the following error:

FATAL 2: open of /2/var/lib/postgres/data/pg_clog/0002 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

We have run a disk check on the relevant partition and it appears to be
fine.

We have several postgres instances on other machines and we have never seen
this problem before. Does anyone have any ideas what the problem is/ what
the right way of dealing with this is?

Thanks for your help.

Ben

--
Ben Roberts
Sysadmin Team
Runtime Collective Ltd
http://www.runtime-collective.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yury Bokhoncovich 2002-09-24 14:50:30 Re: Different Port for PostgreSQL?
Previous Message Andy Kriger 2002-09-24 14:49:22 grant/revoke for alter/drop?