Search Postgresql Archives

Re: Fw: slony- No index found

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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..






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux