Обсуждение: Fw: slony- No index found
--- On Mon, 3/21/11, basobdutta kar <basobdutta_kar@yahoo.com> wrote:
|
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@yahoo.com> wrote:
--- On Mon, 3/21/11, basobdutta kar <basobdutta_kar@yahoo.com> wrote:
From: basobdutta kar <basobdutta_kar@yahoo.com>
Subject: Fw: slony- No index found
To: pgsql-general@postgresql.org
Date: Monday, March 21, 2011, 3:02 PM
--- On Mon, 3/21/11, basobdutta kar <basobdutta_kar@yahoo.com> wrote:
From: basobdutta kar <basobdutta_kar@yahoo.com>
Subject: slony- No index found
To: pgsqlgeneral@postgresql.org
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..
On Mon, Mar 21, 2011 at 10:30 AM, Vick Khera <vivek@khera.org> wrote: > > The schemas in the two database must be *identical*. there are specific things you can let be different, but if you arejust starting out, don't try to do that. also, there is a slony mailing list where the experts hang out. Not entirely true. You can have extra indexes on slaves etc. But you must have either primary key or unique indexes that match on both ends.