Maintenance commands on standby servers

From: Sylvain Rabot <sylvain(at)abstraction(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Maintenance commands on standby servers
Date: 2011-02-07 19:04:46
Message-ID: 1297105486.2549.6.camel@kheops
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)abstraction(dot)fr>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edoardo Panfili 2011-02-07 19:27:57 Re: postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests
Previous Message Bill Thoen 2011-02-07 18:17:10 Re: Directing Partitioned Table Searches