By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,882 Members | 2,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,882 IT Pros & Developers. It's quick & easy.

Problem: Error:relation "pg_autovacuum" does not exit?

P: 2
I have installed postgresql 8.3.1,import data from a dB to another one.I work in pgadmin 3 . When I choose a table ,select the characteristic?it shows the problem below?
Error:relation "pg_autovacuum" does not exit?
Line1?select* from pg_autovacuum where vacrelid=26769::oid

what is the problem?
How to solve it?
Dec 28 '09 #1
Share this Question
Share on Google+
1 Reply


P: 2
I think it is the answer to the question. From enterprise DB

pg_autovacuum is no more available in PostgreSQL 8.4. i.e you no longer need to insert into the pg_autovacuum catalog to change per-table settings for autovacuum

Now in 8.4, you can set autovacuum table configuration with ALTER TABLE / SET comman
Please use the latest pgAdmin3, which comes as a part of installation of PostgreSQL 8.4 installation.
Dec 29 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.