On Nov 29, 2012 8:59 PM, "Björn Edström" <bjorn@spotify.com> wrote:
>
> Greetings list.
>
> I have a Postgresql 9.0.8 cluster with one master and a few slaves, in
> a hot standby and streaming replication setup. The setup has a single
> database with a single table. The table has a column "updated" of type
> "timestamp".
>
> For maintenance reasons I'd like to create a B-tree (or at least some
> kind of index allowing fast comparisons, "<" and ">" at least).
> However, I'd, if possible, like to create this index on a single
> machine in the cluster and not have it replicated everywhere. When the
> maintenance is done the index should be removed. Hash indices will not
> work in this case - it's non-replicated but does not work for
> comparisons.
>
> Ideas?
This is not possible with streaming replication. You'd have to look at one of the external replication solutions out there, like Slony. In sr, you need to create it on the master and have it replicate everywhere.
/Magnus