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@xxxxxxxxxxxxxxxxxxx] Sent: Tuesday, December 22, 2009 4:44 PM To: as@xxxxxxxxxxxxxxxx Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: relation pg_autovacuum does not exist in postgresql 8.4.2 On Tue, Dec 22, 2009 at 1:18 PM, Antonio Sobalvarro <as@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
