[Pgcluster-general] standalone postmaster

[Ryan Fabella]

Thank you for fast reply,

if let say i just have 1 replication server is down, then i need to
copy data directory ?

if i have scenario
computer A has replication+ cluster +LB
computer B has replication+ cluster +LB
computer C only cluster

A and C in the same subnet and same network infrastructure.
while B is on other site. there is case B is lost connection with A and C
i want to ask is it possible to set cluster on A to read_write and
cluster B to read_write
and also cluster C
then how to sync between all ?

thank you


Best regards,

Ryan Fabella



On Fri, Apr 4, 2008 at 9:02 AM, At.Mitani <mitani at sraw.co.jp> wrote:
> > 1. if my replicator is down, is it possible i just copy data directory
>  > from cluster then preparing new replicator ?
>
>  Does the replicator mean replication server?
>  If so, there is not need to copy data directory to new replication server.
>  When you prepared two replication servers, second replication server takes over automatically if master replication server failed down.
>
>  If you means Cluster DB.
>  When you re-start the cluster DB with -R option,
>  it sync db data directory from master Cluster DB automatically.
>
>
>  >
>  > 2. is there any trial on 5 cluster. is it running well as 3 cluster ?
>
>  I tested with more than 5 cluster DBs.
>  However, performance point of view, the suitable number of cluster db is depend on the hardware/network and variety of query types.
>
>  When you want to provide db service even during recovery/add a cluster db, three or more cluster dbs are required (and one or more load balancer) in your system.
>  But this is a different story from performance.
>
>
>  Regards,
>  --
>  At.Mitani <mitani at sraw.co.jp>
>
>
> _______________________________________________
>  Pgcluster-general mailing list
>  Pgcluster-general at pgfoundry.org
>  http://pgfoundry.org/mailman/listinfo/pgcluster-general
>