From: | gurkan(at)resolution(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | creating table while slony-I replication is running |
Date: | 2006-09-20 23:53:55 |
Message-ID: | 1158796435.4511d493445da@www.resolution.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Talha Khan | 2006-09-21 00:01:21 | Re: What is the Best Postgresql Load Balancing Solution available ? |
Previous Message | Jeff Davis | 2006-09-20 23:33:50 | Re: What is the Best Postgresql Load Balancing Solution |