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

From Amine Tengilimoglu
Subject Re: How to turnoff autovacuum
Date
Msg-id CADTdw-xqzsxQaFLLdq9eduPasPCgZ9hyFMaCTwM-pdS5-K2bLw@mail.gmail.com
Whole thread Raw
In response to Fwd: How to turnoff autovacuum  (mark armon <1994hejian@gmail.com>)
Responses Re: How to turnoff autovacuum  (mark armon <1994hejian@gmail.com>)
List pgsql-admin
You need to delete # sign from the line head.  It should be like this

autovacuum = off 

12 Ara 2020 Cmt 08:31 tarihinde mark armon <1994hejian@gmail.com> şunu yazdı:

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: mark armon
Date:
Subject: Fwd: How to turnoff autovacuum
Next
From: mark armon
Date:
Subject: Re: How to turnoff autovacuum