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

On Wed, Sep 16, 2009 at 14:50, Smrti Atrey <smriti(dot)atrey(at)globallogic(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5061
> Logged by:          Smrti Atrey
> Email address:      smriti(dot)atrey(at)globallogic(dot)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/