[Pgcluster-general] Sample config files

[Crespo, Daniel @ SDS]

I saw them, but it doesn't work properly. For example, some people say that in the secondary server, one has to have the cascaded reference to the replicator in server 1 in order to failover. You don't have it there. I'm talking about putting:

<Replicate_Server_Info>
        <Host_Name> rep_1 </Host_Name>
        <Port> 8001 </Port>
        <RLOG_Port> 8301 </RLOG_Port>
        <Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>

In pgreplicate.conf in server 2
With this, when I shutdown the replicator in server 1, it takes over. But for what I really need, nothing works:

I have following configuration:
Node1: db1, rep1
Node2: db2, rep2, lb

I start everything and the replication just goes alright. The problemSSSSS come when I unplug the eth cable of either of both nodes. If I disconnect the eth cable of Node1, I expect to access db2 using lb transparently. It doesn't work. I hangs. In order for lb to work, I have to stop everything in node 2, restart postgres and then restart lb, (in node 2, of course), and then I'm able to work with the database. But it also has problems: when I try to create a table (which doesn't exist), it complains saying that it already exists! Then, I list the tables, and walá, it's there. There are too many inconsistencies, so I'm giving up with using this piece of software.

Maybe it's a config file issue, so I'm attaching them for its evaluation. Thanks.

Daniel


-----Original Message-----
From: pgcluster-general-bounces at pgfoundry.org [mailto:pgcluster-general-bounces at pgfoundry.org] On Behalf Of John Gardner
Sent: Wednesday, June 27, 2007 2:10 PM
To: pgcluster-general at pgfoundry.org
Subject: Re: [Pgcluster-general] Sample config files


Crespo, Daniel @ SDS wrote:
> Hello,
>  
> I've read that in /usr/local/pgsql/shared there are sample config 
> files.
> I can't find them in my box. Can anyone provide them in this list?
>  
> What I basically need are sample config files for a 2 machines HA
> configuration.
>  
> Thanks in advance
>  
> Daniel
> 

Daniel

I posted a my config files a few months ago on http://www.pgcluster.org

John

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general at pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgcluster-general
-------------- next part --------------
A non-text attachment was scrubbed...
Name: clusters.zip
Type: application/x-zip-compressed
Size: 2618 bytes
Desc: clusters.zip
Url : http://pgfoundry.org/pipermail/pgcluster-general/attachments/20070627/bd88a32a/attachment-0001.bin