BUG #5061: pg_autovacuum is not in 8.4 Version

On Wed, Sep 16, 2009 at 14:50, Smrti Atrey <smriti.atrey@globallogic.com> wrote:

The following bug has been logged online:

Bug reference:      5061
Logged by:          Smrti Atrey
Email address:      smriti.atrey@globallogic.com
PostgreSQL version: 8.4
Operating system:   Suse 11.1
Description:        pg_autovacuum is not in 8.4 Version
Details:

Hi

We are using slony 2.0.2-1 and postgres 8.4 version.
Slony is using the below query
select enabled into c_enabled from "pg_catalog".pg_autovacuum where vacrelid
= c_table;

and fails to found pg_autovacuum in pg_catalog.

Please tell what should we use for that. Is there any patch available for
that.

You need slony 2.0.3 in order for 8.4 to be supported. It's available
as a release candidate, IIRC.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/