Lists: | pgsql-hackers |
---|
From: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | about postgres-r setup. |
Date: | 2008-07-28 10:41:30 |
Message-ID: | 488DA25A.30406@alibaba-inc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
hi,
i have setup a postgres-r environment, including two nodes, and
1) the Ensemble daemon run with default configure (means no command options)
2) set the internal variable
repl_default_gcs = 'ensemble'
at postgresql.conf
3) all initial sql script initialized at node1 and node2 as follows:
create database data;
\c data;
create table foo (id serial primary key, n text);
4) execute sql:
alter database data start replication in group tst;
at node1, and seems everything is ok:
NOTICE: Applying for membership in the communication group...
NOTICE: Successfully started replication.
ALTER DATABASE
5)execute sql:
alter database data accept replication from group tst;
at node2, and the psql command is hung up,
NOTICE: Applying for membership in the communication group...
NOTICE: Successfully joined the replication group. Now recovering schema...
so, i dont know what happened, pls give me some advice.
thanks.
best,
leiyonghua
From: | Markus Wanner <markus(at)bluegap(dot)ch> |
---|---|
To: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: about postgres-r setup. |
Date: | 2008-07-29 22:14:00 |
Message-ID: | 488F9628.8020705@bluegap.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hello Leiyonghua,
thanks for trying out Postgres-R.
leiyonghua wrote:
> NOTICE: Applying for membership in the communication group...
> NOTICE: Successfully joined the replication group. Now recovering schema...
>
> so, i dont know what happened, pls give me some advice.
Please compile with '--enable-debug' and '--enable-cassert' and check
the log.
The schema recovery has not been implemented, yet. So I find it pretty
suspicious it is hanging there. Although, I must admit I didn't try the
ensemble interface layer for a while.
Regards
Markus
From: | Markus Wanner <markus(at)bluegap(dot)ch> |
---|---|
To: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: about postgres-r setup. |
Date: | 2008-07-30 07:56:39 |
Message-ID: | 48901EB7.9030102@bluegap.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hello Leiyonghua,
leiyonghua wrote:
> at node2, and the psql command is hung up,
>
> NOTICE: Applying for membership in the communication group...
> NOTICE: Successfully joined the replication group. Now recovering schema...
I've just tested the very same here with ensemble, and could reproduce
the situation. It had to do with the ensemble receive buffer being too
small to hold the recovery data. That's fixed in today's snapshot. With
that I've been able to replicate simple tuples again.
Regards
Markus Wanner
From: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
---|---|
To: | Markus Wanner <markus(at)bluegap(dot)ch> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: about postgres-r setup. |
Date: | 2008-07-30 08:26:23 |
Message-ID: | 489025AF.2080400@alibaba-inc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Markus Wanner 写道:
> Hello Leiyonghua,
>
> leiyonghua wrote:
>> at node2, and the psql command is hung up,
>>
>> NOTICE: Applying for membership in the communication group...
>> NOTICE: Successfully joined the replication group. Now recovering
>> schema...
>
> I've just tested the very same here with ensemble, and could reproduce
> the situation. It had to do with the ensemble receive buffer being too
> small to hold the recovery data. That's fixed in today's snapshot.
> With that I've been able to replicate simple tuples again.
>
that's cool ! i will try later.
> Regards
>
> Markus Wanner
>
>
>
leiyonghua
From: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
---|---|
To: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
Cc: | Markus Wanner <markus(at)bluegap(dot)ch>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: about postgres-r setup. |
Date: | 2008-08-18 04:22:57 |
Message-ID: | 48A8F921.6060205@alibaba-inc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
leiyonghua 写道:
> Markus Wanner 写道:
>> Hello Leiyonghua,
>>
>> leiyonghua wrote:
>>> at node2, and the psql command is hung up,
>>>
>>> NOTICE: Applying for membership in the communication group...
>>> NOTICE: Successfully joined the replication group. Now recovering
>>> schema...
>>
>> I've just tested the very same here with ensemble, and could
>> reproduce the situation. It had to do with the ensemble receive
>> buffer being too small to hold the recovery data. That's fixed in
>> today's snapshot. With that I've been able to replicate simple tuples
>> again.
>>
> that's cool ! i will try later.
>> Regards
>>
>> Markus Wanner
>>
>>
>>
> leiyonghua
>
today, i try the snap-shot
postgres-r-20080813.diff
and still same status.
leiyonghua
From: | Markus Wanner <markus(at)bluegap(dot)ch> |
---|---|
To: | leiyonghua <leiyonghua(at)alibaba-inc(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: about postgres-r setup. |
Date: | 2008-08-19 11:52:56 |
Message-ID: | 48AAB418.1050904@bluegap.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi leiyonghua,
leiyonghua wrote:
> and still same status.
Uh.. do you have debugging enabled? Any logging output of the two
postmaster processes?
Regards
Markus