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