Re: [GENERAL] creating table while slony-I replication is running

2006-09-21 Thread gurkan
Hi, I got executing the script; (creates table on master,slave1,slave2 but does it matter to have connection to only node1 or all nodes in script, it did the same thing with connection to only node1 and I tried to connection to all nodes ? node 1 admin conninfo = 'dbname=development host=192.168.1

Re: [GENERAL] creating table while slony-I replication is running

2006-09-20 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] wrote: > Hi, > I am trying to find out how to CREATE a table while Slony-I replication is > running (meaning without stopping Slony-I replication adding/creating new > table > into replication) I think you have some extra characters in the script.

Re: [GENERAL] creating table while slony-I replication is running

2006-09-20 Thread Shoaib Mir
Hi Gurkan,I just tried the same but didn't face a problem while doing so. You can try the same steps that I did:1. Made a exec_scr fileĀ  for Slonik with execute script command (i.e attached with the email) 2. Made a test.sql file which has the create table just like the one you mentioned (i.e attac

[GENERAL] creating table while slony-I replication is running

2006-09-20 Thread gurkan
Hi, I am trying to find out how to CREATE a table while Slony-I replication is running (meaning without stopping Slony-I replication adding/creating new table into replication) I have tried to run this but wont work. please help. thanks. add_table.sh #!/bin/sh /opt/E