Re: 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