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_...@yahoo.com>wrote: > > > --- On *Mon, 3/21/11, basobdutta kar <basobdutta_...@yahoo.com>* wrote: > > > From: basobdutta kar <basobdutta_...@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_...@yahoo.com>* wrote: > > > From: basobdutta kar <basobdutta_...@yahoo.com> > Subject: slony- No index found > To: pgsqlgene...@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.. > > > > >
