Re: How to turnoff autovacuum

[Amine Tengilimoglu <aminetengilimoglu@xxxxxxxxx>]

You're welcome! 

12 Ara 2020 Cmt 09:34 tarihinde mark armon <1994hejian@xxxxxxxxx> şunu yazdı:

resolved. Thank you very much!!!

On Sat, Dec 12, 2020 at 11:21 AM Amine Tengilimoglu <aminetengilimoglu@xxxxxxxxx> wrote:

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@xxxxxxxxx> ş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.