Re: Missing clog, PITR

From: Richard Huxton <dev(at)archonet(dot)com>
To: Patryk Sidzina <ps(at)heuthes(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Missing clog, PITR
Date: 2010-02-22 20:08:46
Message-ID: 4B82E44E.4030002@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22/02/10 09:57, Patryk Sidzina wrote:
> Hello everyone,
>
> my company has been using pg_standby as a replication solution for a
> while and it has been working great for our needs. Unfortunately, about
> once a month we get the following error on the standby bases:
>
> vacuumdb: vacuuming of database "xxxx" failed: ERROR: could not access
> status of transaction 3625953267
> DETAIL: Could not open file "pg_clog/0D81": No such file or directory.

Is vacuum running on the standby? It's been a long day here, but I'm not
sure that makes sense.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniele Varrazzo 2010-02-22 20:09:33 Re: Info about concurrent sequential scans
Previous Message Yang Zhang 2010-02-22 20:05:17 Re: Sorting performance vs. MySQL