Thread: BUG #5061: pg_autovacuum is not in 8.4 Version

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.

thanks
Smriti

On Wed, Sep 16, 2009 at 14:50, Smrti Atrey <smriti.atrey@globallogic.com> w=
rote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05061
> Logged by: =A0 =A0 =A0 =A0 =A0Smrti Atrey
> Email address: =A0 =A0 =A0smriti.atrey@globallogic.com
> PostgreSQL version: 8.4
> Operating system: =A0 Suse 11.1
> Description: =A0 =A0 =A0 =A0pg_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 vacre=
lid
> =3D 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.

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