On Wednesday 03 September 2008 11:29:10 am Vivek Khera wrote:
> On Wed, Sep 3, 2008 at 11:19 AM, David Lee Lambert
>
> <dlambert at bmtcarhaul.com>wrote:
> > Let's say I have three servers,  X, Y and P.  X and Y are "test"
> > instances, P
> > is "production" (or closer to it).  X and Y have Slony installed, P has
> > not been used for Slony before.  Can I install Slony on P and use the
> > same set definition to start replicating to Y from P?  Or do I need to
> > create a new set, even though the table-names would be the same?
> >
> > What's a good sequence of commands to do this?
>
> Yes, you can do this.  Something along these lines:
>
> First, create the DB and load an empty schema identical to the origin's
> schema.

Thanks,  but I'm not sure we're talking about the same problem.

X, Y and P have exactly the same schema already.

X has stale test data.  Y has an up-to-date exact replica of the stale test 
data.

P has production data.  I want Y to have an up-to-date exact replica of the 
production data.

In the language of slon_tools.conf,  my current configuration is

add_node(node => 5, host => 'x.example.com', dbname=> 'data' );
add_node(node => 6, host => 'y.example.com', dbname=> 'data' );
$MASTERNODE = 5;
$SLONY_SETS = { 'set1' => { "origin" => 5 ... } }

and I want

add_node(node => 1, host => 'p.example.com', dbname=>'data' );
add_node(node => 6, host => 'y.example.com', dbname=>'data' );
$MASTERNODE = 1;
$SLONY_SETS = { 'set1' => { "origin" => 1 ... } };

I know I can do

dropdb -h y.example.com data

and reinstall the schema and Slony; but is there a faster way?


-- 

David L. Lambert
  Software Developer,  Precision Motor Transport Group, LLC
  Work phone 517-349-3011 x215
  Cell phone 586-873-8813