Re: Fw: slony- No index found - Mailing list pgsql-general

From Vick Khera
Subject Re: Fw: slony- No index found
Date
Msg-id AANLkTik1JoYmwHhawL5JqjH1E_H71bLOBwPZrnxMtXPc@mail.gmail.com
Whole thread Raw
In response to Fw: slony- No index found  (basobdutta kar <basobdutta_kar@yahoo.com>)
Responses Re: Fw: slony- No index found  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
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..





pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: query execution time
Next
From: tv@fuzzy.cz
Date:
Subject: Re: query taking much longer since Postgres 8.4 upgrade