On Tue, 2011-02-08 at 21:05 +0900, Fujii Masao wrote:
> On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot wrote:
> > Is it possible to run maintenance commands like ANALYZE, VACUUM, CLUSTER
> > on a standby server ?
>
> No.
>
> Since the effect of the maintenance command on the primary server
> is a
On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot wrote:
> Is it possible to run maintenance commands like ANALYZE, VACUUM, CLUSTER
> on a standby server ?
No.
Since the effect of the maintenance command on the primary server
is also replicated, you don't need to do that on the standby.
Regards,
-
Hi,
Is it possible to run maintenance commands like ANALYZE, VACUUM, CLUSTER
on a standby server ?
The documentations says that those operations can not be done in
recovery mode, but that "some of these commands are actually allowed
during "read only" mode transactions on the primary" [1].
[1]
h
