Thread: Maintenance commands on standby servers

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]
http://www.postgresql.org/docs/9.0/static/hot-standby.html#HOT-STANDBY-ADMIN

Regards.

--
Sylvain Rabot <sylvain@abstraction.fr>

On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot <sylvain@abstraction.fr> 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,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

On Tue, 2011-02-08 at 21:05 +0900, Fujii Masao wrote:
> On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot <sylvain@abstraction.fr> 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,
>

Thank you for your explanation.

--
Sylvain Rabot <sylvain@abstraction.fr>