From: | Andy <angelflow(at)yahoo(dot)com> |
---|---|
To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tutorials on high availability Postgresql setup? |
Date: | 2010-10-07 07:53:50 |
Message-ID: | 882315.50279.qm@web111309.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- On Thu, 10/7/10, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
> > The scenario I'm most interested in is this:
> >
> > 2 servers - a master and a hot standby. All writes are
> sent to master, reads are split between master and hot
> standby.
> >
> > 1) If the hot standby goes down, how do I redirect
> reads to the master?
>
> pgpool-II 3.0 will take care of this.
>
> > 2) If the master fails
> > -how do I automatically
> promote the standby to master and send all reads/writes to
> the new master?
>
> This is covered by pgpool-II 3.0 as well.
>
> > -what happens when the old
> master comes back up? Do I need to so anything to make it
> catches up to the new master?
>
> I recommend to use it a standby. Such a configuration is
> possible by
> using pgpool-II 3.0.
> --
Oh so I'd still need a proxy such as pgpool-II for HA setup?
I was thinking that with the new built-in replication in 9.0 there would be no need to use pgpool-II.
If pgpool is still necessary why not also use it for replication? What would be the advantages of using the 9.0's built-in replication as opposed to pgpool's replication?
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-10-07 07:58:44 | Re: Tutorials on high availability Postgresql setup? |
Previous Message | Tatsuo Ishii | 2010-10-07 07:40:29 | Re: Tutorials on high availability Postgresql setup? |