Postgres Pro
Downloads
Home   >   mailing lists

Fwd: How to turnoff autovacuum - Mailing list pgsql-admin

From mark armon
Subject Fwd: How to turnoff autovacuum
Date
Msg-id CACh77r71Ar=o3qK7R38S1vYVgB=0Erp6LoS-aOk8TyVcV-hR7A@mail.gmail.com
Whole thread Raw
Responses Re: How to turnoff autovacuum  (Amine Tengilimoglu <aminetengilimoglu@gmail.com>)
Re: How to turnoff autovacuum  (Keith <keith@keithf4.com>)
List pgsql-admin
Tree view

Just follow the tutorial. In the tutorial I need to set the autovacuum off. 
Here is how I set the autovacuum off. 
  1. Locate the postgresql.conf.  
  2. edit the postgresql.conf using notepad. As the picture attached. Previously it's on now it's off. 
  3. close and save postgresql.conf then open service-msc
  4. restart  the postgresql service. 
  5. open psql type: show autovacuum; 
But the result is ON. 

So that's my knowledge about  how to set the parameters. But it failed. So please tell me how to set the autovacuum off. 
image.png
Attachment

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Next
From: Amine Tengilimoglu
Date:
Subject: Re: How to turnoff autovacuum