Hi,

 

This is my first test implementation.

 

I was able to replicate the pgbench database on the SAME machine to
pgbenchslave database. What I would like to do next is replicate ANOTHER
new database from the master to a NEW, separate machine, which will act
as the slave.

 

This is all test scenario, so one option is to uninstall the nodes, and
start fresh.

 

Would the other option be to define a 'node 3' with the new db
(dbname=newdb host=192.168.8.70), and then replicate it to a new node 4
(dbname=newdb host=192.178.8.71)?  Or maybe, I can define a NEW cluster
alongside the 'slonytest' cluster?

 

 

Thanks,
Anjan

 

 

Following is the current config on the one machine:

 

#localhost is 192.168.8.70 here

...

cluster name = slonytest;

 

node 1 admin conninfo = 'dbname=pgbench host=localhost user=postgres';

node 2 admin conninfo = 'dbname=pgbenchslave host=localhost
user=postgres';

init cluster ( id=1, comment = 'Master Node');

...

store node (id=2, comment = 'Slave node');

store path (server = 1, client = 2, conninfo='dbname=pgbench
host=localhost user=postgres');
store path (server = 2, client = 1, conninfo='dbname=pgbenchslave
host=localhost user=postgres');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
 
 
 
************************************************************************
******************
This e-mail and any files transmitted with it are intended for the use
of the 
addressee(s) only and may be confidential and covered by the
attorney/client 
and other privileges.  If you received this e-mail in error, please
notify the 
sender; do not disclose, copy, distribute, or take any action in
reliance on 
the contents of this information; and delete it from your system. Any
other 
use of this e-mail is prohibited.
************************************************************************
******************

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050331/0eafb72d/attachment.html