Re: Partitioned tables & Slony

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioned tables & Slony
Date: 2007-12-18 16:17:01
Message-ID: 604peg6kqq.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Goboxe <hadzramin(dot)ar(at)gmail(dot)com> writes:
> What need to be taken care of when replicating data from partitioned
> tables?
>
> I have several master tables that are inherited by date either daily,
> weekly and monthly.
>
> How to automate addition of newly created child tables into Slony
> cluster?

There's an outline of how to do it, in the partitioning test...

http://main.slony.info/viewcvs/viewvc.cgi/slony1-engine/tests/testpartition/
--
"cbbrowne","@","linuxdatabases.info"
http://linuxfinances.info/info/slony.html
"If we believe in data structures, we must believe in independent
(hence simultaneous) processing. For why else would we collect items
within a structure? Why do we tolerate languages that give us the one
without the other?" -- Alan J. Perlis

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Weber, Geoffrey M. 2007-12-18 16:28:42 Re: Problem with index not being chosen inside PL/PgSQL function...
Previous Message Tom Lane 2007-12-18 16:11:12 Re: Problem with index not being chosen inside PL/PgSQL function...