| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Khangelani Gama *EXTERN*" <kgama(at)argility(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Need help on autovacuum in postgres 9.1.2 |
| Date: | 2012-08-30 11:22:04 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C208588EAF@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2012-08-30 11:29:36 | Re: Dropping a column on parent table doesn't propagate to children? |
| Previous Message | Craig Ringer | 2012-08-30 11:16:31 | Re: Need help on autovacuum in postgres 9.1.2 |