Re: cannot execute VACUUM during recovery

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Stephen Eilert <contact(at)stepheneilert(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, github kran <githubkran(at)gmail(dot)com>
Subject: Re: cannot execute VACUUM during recovery
Date: 2019-02-28 02:29:37
Message-ID: 20190228022937.GI1617@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 27, 2019 at 10:39:10AM -0800, Stephen Eilert wrote:
> Are you running Vacuum on the slave node? It has to run on the master.

VACUUM performs an equivalent write activity so it has to be
restricted. ANALYZE can work though.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Fan 2019-02-28 04:32:34 create unique constraint on jsonb->filed during create table
Previous Message Michael Paquier 2019-02-28 00:41:48 Re: Channel binding not supported using scram-sha-256 passwords