The schemas in the two database must be *identical*. there are specific things you can let be different, but if you are just starting out, don't try to do that. also, there is a slony mailing list where the experts hang out.
On Mon, Mar 21, 2011 at 5:33 AM, basobdutta kar
<basobdutta_kar@xxxxxxxxx> wrote:
--- On Mon, 3/21/11, basobdutta kar <basobdutta_kar@xxxxxxxxx> wrote:
From: basobdutta kar <basobdutta_kar@xxxxxxxxx>
Subject: Fw: slony- No index found
To: pgsql-general@xxxxxxxxxxxxxx
Date: Monday, March 21, 2011, 3:02 PM
--- On Mon, 3/21/11, basobdutta kar <basobdutta_kar@xxxxxxxxx> wrote:
From: basobdutta kar <basobdutta_kar@xxxxxxxxx>
Subject: slony- No index found
To: pgsqlgeneral@xxxxxxxxxxxxxx
Date: Monday, March 21, 2011, 3:01
PM
Sir/Madam,
I have two databases- db1 and db2
db1 is the master and db2 is slave.
In db1, create table t1(id integer primary key);
In db2 , create table t1(id integer);
When i start replicating , why slony gives error cannot find index on id.
But in place of integer ,if i use int4 datatype,
data is replicating properly.
How to solve the problem... Its urgent..
|
|
|
