Re: relation pg_autovacuum does not exist in postgresql 8.4.2

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