Re: Fw: slony- No index found

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fw: slony- No index found
Date: 2011-03-21 16:30:44
Message-ID: AANLkTik1JoYmwHhawL5JqjH1E_H71bLOBwPZrnxMtXPc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yahoo(dot)com>wrote:

>
>
> --- On *Mon, 3/21/11, basobdutta kar <basobdutta_kar(at)yahoo(dot)com>* wrote:
>
>
> From: basobdutta kar <basobdutta_kar(at)yahoo(dot)com>
> Subject: Fw: slony- No index found
> To: pgsql-general(at)postgresql(dot)org
> Date: Monday, March 21, 2011, 3:02 PM
>
>
>
> --- On *Mon, 3/21/11, basobdutta kar <basobdutta_kar(at)yahoo(dot)com>* wrote:
>
>
> From: basobdutta kar <basobdutta_kar(at)yahoo(dot)com>
> Subject: slony- No index found
> To: pgsqlgeneral(at)postgresql(dot)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..
>
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tv 2011-03-21 16:32:40 Re: query taking much longer since Postgres 8.4 upgrade
Previous Message Scott Ribe 2011-03-21 16:06:34 Re: query execution time