Re: temporarily disable autovacuum on a database or server ?

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Thu, Jan 12, 2017 at 12:09 PM, Jonathan Vanasco <postgres@xxxxxxxx> wrote:

On Jan 11, 2017, at 8:19 PM, Melvin Davidson wrote:

Yes, you're right about ALTER SYSTER. Unfortunately, the op provided neither PostgreSQL version or O/S, so we can't even be sure that is

an option. That is  why I stated "I cannot confirm".

I didn't think that would matter, but postgres 9.6.1 and ubuntu 16.04

anyways, thanks.  i'll test that approach.

Jonathan,

I've tested this in PostgreSQL 9.4.6, so it should work for 9.6.1 also

Edit the postgresql.conf and change
#autovacuum = on

to
autovacuum = off

and save it.

Then
psql -U postgres -c "SELECT pg_reload_conf();"

No need to restart postgres.

After you finish your processing, do not forget to re-edit postgresql.conf

and change
autovacuum = off

to
autovacuum = on

save and

psql -U postgres -c "SELECT pg_reload_conf();"

--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.