.pgpass setup on this linux instance so I had to manually enter
the password here. VACUUM on the table Iam running does not work and throws
an error as ERROR: cannot execute VACUUM during recovery
2) Running from Linux Instance2
Command Iam running -> psql -d myPostgresDB -h clusterName -U myUs
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
n 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
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