Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot execute VACUUM during recovery - Mailing list pgsql-general

From Stephen Eilert
Subject Re: cannot execute VACUUM during recovery
Date
Msg-id 0039a47f-562c-4d61-9096-8f7f7743bbd1@Spark
Whole thread Raw
In response to cannot execute VACUUM during recovery  (github kran <githubkran@gmail.com>)
Responses Re: cannot execute VACUUM during recovery  (Michael Paquier <michael@paquier.xyz>)
Re: cannot execute VACUUM during recovery  (github kran <githubkran@gmail.com>)
List pgsql-general
Tree view
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@gmail.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

pgsql-general by date:

Previous
From: Scottix
Date:
Subject: Optimizing Database High CPU
Next
From: Joe Conway
Date:
Subject: Re: why not using a mountpoint as PGDATA?