Hi All, I was reading in the Slony 1.2.16 documentation on maintenance section 6.1 - Interaction with PostgreSQL autovacuum. In the documentation, there is this query which was recommended to execute in order to exclude some slony tables from being run by the Postgres autovacuum features. I am running Postgres 8.1.7 on Debian Etch. The command to run the exclusion: INSERT INTO pg_catalog.pg_autovacuum (vacrelid, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit, freeze_min_age, freeze_max_age) SELECT oid, 'f', -1, -1, -1, -1, -1, -1, -1, -1 FROM pg_catalog.pg_class WHERE relnamespace = (SELECT OID FROM pg_namespace WHERE nspname = '_' || 'MyCluster') AND relhasindex; When executing the command, Postgres complain of the column "freeze_min_age" does not exist. I look at the schema of pg_catalog.pg_autovacuum and found that "freeze_min_age" and "freeze_max_age" are not defined. Is it ok to exclude the last 2 variables in the "insert into pg_catalog.pg_autovacuum ...." statement? Will it have any impact?
Regards, Lawrence Giam <http://www.globalitcreations.com/> ........................................................................ .......................... Lawrence Giam | Global IT Creations Pte Ltd | Network Administrator website: http://www.globalitcreations.com <http://www.globalitcreations.com/> phone: +65 6836 4768 ext 115| fax: + 65 6836 4736 | mobile: + 65 9758 7448
<<att9D6.jpg>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
