Re: Missing clog, PITR

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