Gordon Shannon gordo169 at gmail.com
Thu Jul 16 06:10:19 PDT 2009
I'm trying to run Slony 2.0.2 with Postgres 8.4.  I'm getting this error:

14 0716 03:41:58 ERROR  cleanupThread: "select nspname, relname from
"_slony_cluster".TablesToVacuum();" - ERROR:  relation
"pg_catalog.pg_autovacuum" does not exist
14 0716 03:41:58 LINE 1: select enabled from "pg_catalog".pg_autovacuum
where vacreli...
14 0716 03:41:58                             ^
14 0716 03:41:58 QUERY:  select enabled from "pg_catalog".pg_autovacuum
where vacrelid =  $1 
14 0716 03:41:58 CONTEXT:  PL/pgSQL function "shouldslonyvacuumtable" line
25 at SQL statement
14 0716 03:41:58 PL/pgSQL function "tablestovacuum" line 6 at IF

It appears they may have dropped the use of the pg_autovacuum table in 8.4
in favor of table creation storage parameters.
-- 
View this message in context: http://www.nabble.com/pg_autovacuum-table-gone-in-8.4--tp24516041p24516041.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.



More information about the Slony1-general mailing list