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.15.90 port=5444 user=enterprisedb'; node 2 admin conninfo = 'dbname=development host=192.168.15.91 port=5444 user=enterprisedb'; node 3 admin conninfo = 'dbname=development host=192.168.15.92 port=5444 user=enterprisedb'; ) (once the table cretaed, I would expect to have replication for all tables and new-created table; meaning once I do insertion to new-created table on master, I was expecting to replicate on slave1 and slave2, but it did not replicate/insert to slave1 and slave2. I am sure I am missing something?) (I believe same things needs to be done for other SQL commands, like inserting INDEXs,FUNCTIONS, etc.) thanks for reply/help >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.eattached with the email) >2. Made a test.sql file which has the create table just like the one you >mentioned (i.e attached with the email) >3. Now using Slonik executed the script test.sql for master and salve like >this > >/opt/EnterpriseDB/8.1.4.17/dbserver/slonik exec_scr > >and that created the same table on the master and respective slave node. > >The encoding error that you are getting might be due to some extra or some >special hidden characters in one of your script files. > >Please try using the script files that I have attached with the email and >following the steps given above. > >Thanks, >-- >Shoaib Mir >EnterpriseDB (www.enterprisedb.com) > >On 9/21/06, gurkan@xxxxxxxxxxxxxx <gurkan@xxxxxxxxxxxxxx> 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 have tried to run this but wont work. please help. thanks. > > add_table.sh > ---------------------------- > #!/bin/sh > > /opt/EnterpriseDB/8.1.4.17/dbserver/bin/slonik <<_EOF_ > #-- > # define the namespace the replication system uses in our example > it is > # slony_example > #-- > cluster name = $CLUSTERNAME; > > node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST > port=$MASTERDBPORT user=$REPLICATIONUSER'; > > EXECUTE SCRIPT ( > SET ID = 1, > FILENAME = > '/opt/EnterpriseDB/8.1.4.17/dbserver/bin/add_table.sql', > EVENT NODE = 1 > ); > > _EOF_ > ---------------------------------- > > add_table.sql > ---------------------------------- > CREATE TABLE gurkan > ( > id serial not null , > fname varchar(155), > lname varchar(155), > primary key (id) > ); > ---------------------------------- > > ERROR: > ------------------------- > [enterprisedb@baba1 bin]$ ./add_table.sh > <stdin>:9: PGRES_FATAL_ERROR select > "_edb_replication_example".ddlScript(1, > 'CREATE TABLE gurkan > ( > id serial not null , > fname varchar(155), > lname varchar(155), > primary key (id) > ); > X\uffff\uffff', -1); - ERROR: invalid byte sequence for encoding > "UNICODE": 0xc1c4 > ------------------------- > ------------------------- > > > ------------------------------------------------- > This mail sent through IMP: www.resolution.com > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ------------------------------------------------- This mail sent through IMP: www.resolution.com
