Re: Maintenance commands on standby servers

From: Sylvain Rabot <sylvain(at)abstraction(dot)fr>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Maintenance commands on standby servers
Date: 2011-02-08 17:31:15
Message-ID: 1297186275.2497.5.camel@kheops
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lee Hughes 2011-02-08 18:41:15 Backup/Restore Needed for Upgrade from 9.0beta4?
Previous Message Robert Fitzpatrick 2011-02-08 17:03:04 Re: plperl.dll on windows with postgresql 9.0.3