Reg Automatic Fail over & Automatic Failback in Pgpool.

From: Gurunadh Venkata <gurunadh(dot)venkata(at)gmail(dot)com>
To: pgpool-general(at)pgpool(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Reg Automatic Fail over & Automatic Failback in Pgpool.
Date: 2015-09-18 08:18:44
Message-ID: CAJAdScaLdJS_AMRyH0wov2+8DnS+wyQq-j-Y+NmmxLyFsSFQ5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear group,

I have setup streaming replication setup with two postgresql 9.3
nodes(master-slave).

And also i have configured the pgpool on the two nodes for load balancing
and High availability.

If Primary node goes down then pgpool can able to make the secondry node as
a primary and that is working fine.

What happens after some point of time if the failed primary node comes
back.How can we manage the replication process with this two nodes.(new
primary node and old node primary node)

Can* Automatic failback *is possible in pgpool if yes please send the
scripts and step's required to setup.

Version of Postgres: 9.3

pgpool 3.3.6

What will be down time of database during this procedure?

Thanks For Your Time.

Thanks & Regards,
G V Gurunadh.

Browse pgsql-novice by date

  From Date Subject
Next Message richard 2015-09-19 09:37:13 can't get pg_stat_statements to work
Previous Message Albe Laurenz 2015-09-17 11:33:11 Re: Could not open file upon startup