Khangelani Gama wrote: > I need help in turning off autovacuum in the Database that's running postgres 9.1.2 DB. I tried to > turn it off by putting "off" in postgresql.cont file and restarted the postmaster but when I run "show > autovacuum; " query I still see autovacuum set on inside the database. > > autovacuum > ------------ > on > (1 row) > > postgresql.conf currently looks as follows. Should I remove the hash sign that's before "autovacuum = > off" ? > > #autovacuum = off # Enable autovacuum subprocess? 'on' [snip] Exactly. See http://www.postgresql.org/docs/9.1/static/config-setting.html "Hash marks (#) designate the rest of the line as a comment." Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
