Thanks very much.  What is the best way to take the slave out of read only
mode so we can alter indexes etc ?

On Dec 18, 2007 12:33 AM, Tomeh, Husam <HTomeh at facorelogic.com> wrote:

>
> 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 =3D table1, table2, table3
>
> set2 =3D 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 legal=
ly
> 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 prohibite=
d.
>  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
> **********************************************************************
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071218/=
be588494/attachment.htm