Re: Fw: slony- No index found

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Fw: slony- No index found
Дата
Msg-id AANLkTik1JoYmwHhawL5JqjH1E_H71bLOBwPZrnxMtXPc@mail.gmail.com
обсуждение исходный текст
Ответ на Fw: slony- No index found  (basobdutta kar <basobdutta_kar@yahoo.com>)
Ответы Re: Fw: slony- No index found  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: query execution time
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: query taking much longer since Postgres 8.4 upgrade