Please see my comments below.

-----Original Message-----
From: "James Tucker" <jameshtucker at gmail.com>
To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info>
Sent: 12/16/2007 5:30 PM
Subject: [Slony1-general] Different indexes on slave

Hi All,

We're currently running slony to replicate to our DR site.  We're looking at
creating another reporting database at each site so our application can use
that for reports etc, and the master for our normal oltp load.  The
reporting database only needs a subset of the tables included in the DR set.


I have 2 questions.

Is there any reason we can't create different indexes (aimed at faster
reports as apposed to OTLP) on the reporting slave ?

[Husam: you should be able to do so. Actually this is one of the advantages of Slony triggered-based replication system.]

Currently I just have one set that includes all our tables, am I able to
create another set with just a selection of those tables ?  Or would I need
to recreate my existing set, splitting it.

[Husam: breaking your set would give you more flexblity - that'd be a good choice.]

i.e.

set1 = table1, table2, table3

set2 = table1, table2.

Thanks in advance.

James


**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************