[Pgcluster-general] Last chance to get everything working

[a.mitani at sra-europe.com]

Hi,

When replication works well, I think basic configuration has no problem.
Therefore the cause of recovery failure may be the setup of rsync.
Would you check it with following page.
http://pgcluster.projects.postgresql.org/rsync.html

In this case,
In each pgreplicate.conf need
1. same order of cluster db and loadbalancer is required.
2. comment out <Replicate_Server_Info> data
3. set 'no' to <Use_Replication_Log>

In each pglb.conf need
1. same order of cluster db is required

In each cluster.conf need
1. same order of replication server
2. set correct path of rsync and pg_dump

Please check each /etc/hosts file.
It's also required same contents.

I believe that take/fail over of replication server and recovery of db
server   may work fine.


Replication Log is used recovery of transaction abort during replicate of
'commit'.
It is required different concept from your requirement.

Regards,
----------------
At.Mitani

> I've been working with pgCluster for the last four months now, I'm at
> the stage where we need to install it in a production environment, but I
> must say that I'm still apprehensive about a few things, some things
> certainly don't work in my environment.  I have chatted with Rick Vernam
> about a few of these problems, and although we seem to have the same
> configuration, his works and mine doesn't.
>
> My configuration is this:
>
>     DB 1               DB 2                                DB 3
> +--------------+   +--------------+                  +--------------+
> |   cluster_1  |   |   cluster_2  |       VPN        |   cluster_3  |
> |   rep_1      |---|   rep_2      |------------------|   rep_3      |
> |   lb_1       |   |   lb_2       |                  |              |
> +--------------+   +--------------+                  +--------------+
>        |                   |
>        |                   |
> +--------------+   +--------------+
> |   Apache     |   |   Apache     |
> |   mod_jk     |   |   mod_jk     |
> |   Tomcat     |---|   Tomcat     |
> +--------------+   +--------------+
>      APP 1APP 2
>
> My problems are:
>
> - Replication works between all of the nodes under normal circumstances.
> - Multiple replicator failover doesn't work.
> - Occasionally when bringing a DB Cluster node back up in recovery mode,
> access to the remaining DB clusters locks and I can't access anything
> either via the load balancer or directly.
> - Does <Response_Mode> have any use at all? One of the reasons for going
> down the pgCluster route was the 'normal' operation, but I've just read
> a post on the mailing list from Atsushi saying that normal operation
> doesn't work and should be removed.
> - What is the difference of setting <Use_Replication_Log> to yes or no?
>
> We really, have to make a decision this week, whether we stick with
> pgCluster or go via another route.  I've stuck with pgCluster for this
> long because I was convinced that the reason it was not performing as I
> had expected was due to configuration errors, but now I'm not so sure...
> If anyone can give me any help I would be extremely grateful!
>
> Thanks in advance
>
> John
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>