Re: Need help on autovacuum in postgres 9.1.2

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