Re: How to turnoff autovacuum

You're welcome!

12 Ara 2020 Cmt 09:34 tarihinde mark armon <1994hejian(at)gmail(dot)com> şunu
yazdı:

>
> 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]
>>>
>>