On 9/11/2007 2:25 AM, Jan Matousek wrote:
> Hi,
> 
> in Slony1, the "unit of replication" is set, which consist of explicitly 
> selected tables from some particular database. So the answer is yes, to 
> replicate some schemas just create set (or sets) that consists of all 
> tables in that schemas.

However, be warned that you will have to specify each and every single 
table and sequence you want to be replicated. There is no "automagic" 
replication of "entire schema" including DDL statements or the like.


Jan



> 
> j.
> 
> On 9/11/07, *Matthew Boehm* <mboehm at voilaip.com 
> <mailto:mboehm at voilaip.com>> wrote:
> 
>     Hey gang,
>       Newbie Slony1 user here. Is it possible to replicate just 1 particular
>     database or a select number of schemas? We have no need to replicate the
>     entire server.  pgcluster doesn't have this ability so I'm searching
>     here now.
> 
>     Thanks,
>     Matthew
>     _______________________________________________
>     Slony1-general mailing list
>     Slony1-general at lists.slony.info <mailto:Slony1-general at lists.slony.info>
>     http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #