Search Postgresql Archives

Re: relation pg_autovacuum does not exist in postgresql 8.4.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux