Re: How to turnoff autovacuum

From: Amine Tengilimoglu <aminetengilimoglu(at)gmail(dot)com>
To: mark armon <1994hejian(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to turnoff autovacuum
Date: 2020-12-12 05:51:01
Message-ID: CADTdw-xqzsxQaFLLdq9eduPasPCgZ9hyFMaCTwM-pdS5-K2bLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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]
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mark armon 2020-12-12 06:34:02 Re: How to turnoff autovacuum
Previous Message mark armon 2020-12-12 05:30:37 Fwd: How to turnoff autovacuum