relation pg_autovacuum does not exist in postgresql 8.4.2

Hi,

I installed Postgresql 8.4.2 on Centos
5.4 64 bit.

I migrated data from postgres 8.3 to
8.4.2 using PgAdmin 1.10 backup and
restore functions.

We access the data using ODBC.

For some reports, we need to create a
temporal table, fill it and then drop
it.

This kind of programs get the error
message “relation pg_autovacumm does not
exist”.

We configured autovacuum=on in
postgresql.conf.

I am awere that pg_catalog.pg_autovacuum
does not exist in 8.4 version.

Please advise.

Thank you.

Antonio Sobalvarro

Soluciones Estrategicas S.A.

Avenida Reforma 6-39 zona 10

Edificio Guayacán Oficina 1203

Codigo Postal 01010

Guatemala, Centro América

Teléfono +502 2379-4860

email <mailto:as(at)estrategicas(dot)com>
as(at)estrategicas(dot)com

web <http://www.estrategicas.com>
www.estrategicas.com

web <http://www.mobilges.com>
www.mobilges.com

On Tue, Dec 22, 2009 at 1:18 PM, Antonio Sobalvarro <as(at)estrategicas(dot)com> wrote:
>
> This kind of programs get the error message “relation pg_autovacumm does not
> exist”.
>

what programs are failing?
anyway, the error is that those programs are accesing a catalog that
doesn't exist anymore (actually i consider an error to access a
catalog from an user application but...)
if they are your programs and you have source code you can change them.
if not, you can try to recreate the catalog for yourself but for do
that you need:

1) stop the service and start in standalone mode with catalog changes allowed
2) create pg_catalog.pg_autovacuum with structure it has until 8.3 (i
guess if those programs are broken enough to ask for the catalog maybe
it is also asking for specific columns of the catalog)
3) Exit and start the service again

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Thank you Jaime for your support.

I will ask the developers to check on
the software and locate which programs
are trying to access pg_autovacuum
catalog.

Also will try to create the
pg_autovacuum table.

Regards,

Antonio Sobalvarro
Soluciones Estrategicas S.A.
Avenida Reforma 6-39 zona 10
Edificio Guayacán Oficina 1203
Codigo Postal 01010
Guatemala, Centro América
Teléfono +502 2379-4860

-----Original Message-----
From: Jaime Casanova
[mailto:jcasanov(at)systemguards(dot)com(dot)ec]
Sent: Tuesday, December 22, 2009 4:44 PM
To: as(at)estrategicas(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] relation
pg_autovacuum does not exist in
postgresql 8.4.2

On Tue, Dec 22, 2009 at 1:18 PM, Antonio
Sobalvarro <as(at)estrategicas(dot)com> wrote:
>
> This kind of programs get the error
message “relation pg_autovacumm does not
> exist”.
>

what programs are failing?
anyway, the error is that those programs
are accesing a catalog that
doesn't exist anymore (actually i
consider an error to access a
catalog from an user application but...)
if they are your programs and you have
source code you can change them.
if not, you can try to recreate the
catalog for yourself but for do
that you need:

1) stop the service and start in
standalone mode with catalog changes
allowed
2) create pg_catalog.pg_autovacuum with
structure it has until 8.3 (i
guess if those programs are broken
enough to ask for the catalog maybe
it is also asking for specific columns
of the catalog)
3) Exit and start the service again

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157