Re: cannot execute VACUUM during recovery

2019-03-02 Thread github kran
On Wed, Feb 27, 2019 at 12:39 PM Stephen Eilert wrote: > Are you running Vacuum on the slave node? It has to run on the master. > > Thanks, > > – Stephen > Thanks Stephen for your advice Iam running the VACUUM command from 2 of the linux instances using the below command. We were running some

Re: cannot execute VACUUM during recovery

2019-02-27 Thread Michael Paquier
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 signature.asc Description: PGP signature

Re: cannot execute VACUUM during recovery

2019-02-27 Thread Stephen Eilert
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 , 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.