roctaiwan <nettreeinc at gmail.com> writes:

> Hi all,
>
> I wants to know what will Slony replicating and what will not? 
>
> will it replicating Schema? Index? functions? 

<http://slony.info/documentation/slonyintro.html#INTRODUCTION>
Section 1.5 describe what *is* replicated.

> I am concerning about Indexes, since it would affect performance on user
> from retrieving data from my slave nodes. 

Indexes are derived from the contents of the underlying table, so if
you have the schema defined on the subscribers, complete with indices,
then the indices will exist and be used as would be expected.

> If there a solution for this issue? or it has to done by hand manually doing
> dumpall to slaves?

You need to have the proper schema on all nodes.

There is a script called <slony1_dump.sh> which can pull this from the
origin if it is not already available.
-- 
let name="cbbrowne" and tld="ca.afilias.info" in name ^ "@" ^ tld;;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"