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