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