From: | gurkan(at)resolution(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: creating table while slony-I replication is running |
Date: | 2006-09-21 15:13:57 |
Message-ID: | 1158851637.4512ac35a3761@www.resolution.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)resolution(dot)com <gurkan(at)resolution(dot)com> 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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Lorentsen | 2006-09-21 15:30:24 | Replication and PITR |
Previous Message | Scott Marlowe | 2006-09-21 15:12:28 | Re: column names in select don't exists in insert to |