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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
