Re: How to turnoff autovacuum

resolved. Thank you very much!!!

On Sat, Dec 12, 2020 at 11:21 AM Amine Tengilimoglu <
aminetengilimoglu(at)gmail(dot)com> 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(at)gmail(dot)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: image.png]
>>
>