Re: cannot execute VACUUM during recovery

From: Stephen Eilert <contact(at)stepheneilert(dot)com>
To: 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-27 18:39:10
Message-ID: 0039a47f-562c-4d61-9096-8f7f7743bbd1@Spark
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Are you running Vacuum on the slave node? It has to run on the master.

Thanks,

– Stephen
On Feb 27, 2019, 6:43 AM -0800, github kran <githubkran(at)gmail(dot)com>, wrote:
> Hello Team,
>
> We are using a PostgreSQL 9.6 and seeing the below error while trying to run a VACUUM on one of our live tables running in Production. We wanted to clean up some DEAD tuples on the table.
>
>
> Command: VACUUM (ANALYZE,VERBOSE) table_name.
>
> ERROR:  cannot execute VACUUM during recovery
>
> Thanks
> Kranthi

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2019-02-27 18:43:44 Re: why not using a mountpoint as PGDATA?
Previous Message Scottix 2019-02-27 18:08:43 Optimizing Database High CPU