| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgpool2 master fail problem |
| Date: | 2012-04-20 00:26:55 |
| Message-ID: | 4F90AD4F.6030608@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 04/17/12 7:10 AM, Videanu Adrian wrote:
> i try to build a postgresql cluster using postgresql 9.1.3 and pgpool2 3.1.2.
> I want to setup this cluster as a master/slave with streaming copy. Everything is ok execept the case when the masters fails, and i try to recover it, because the old master recovers as master instead of slave. I have installed pgpool-walrecrunning on both servers but still does not seems to work.
in addition to the streaming replication built into postgres, you need
some form of cluster management software running over the top of this to
manage the transition states, ensure that you don't have two masters,
etc. as another said, the previously failed master has to be brought
online as a new slave
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tuanhoanganh | 2012-04-20 03:25:05 | Re: pgstat wait timeout |
| Previous Message | Tatsuo Ishii | 2012-04-20 00:22:38 | Re: pgpool2 master fail problem |