From: Gaetano Mendola <mendola@bigfoot.com>
To: Negyesi Karoly <chx@mail.tvnet.hu>
Subject: Re: replication and linux-ha?
Date: Thu, 29 Jul 2004 18:29:10 +0200
Message-ID: <410925D6.5040307@bigfoot.com> (raw)
In-Reply-To: <200472316751.883245@wood>
References: <200472316751.883245@wood>
Negyesi Karoly wrote:
> Welcome,
>
> I am planning to do a linux-ha cluster. Is replication applicable in a
> solution like this? The main questions are that after the main node
> fails and the slave node becomes the master:
>
> -- a postmaster, started as slave, will be able to work standalone?
> -- after repairing the main node, it will become the slave node, so the
> aforementioned postmaster shall become master. Is this possible?
>
> Thanks
>
> Karoly Negyei
Yes you can, you have to define a service with a IP address, so when
the service postgres is relocated in the passive node also the IP
is migrated.
And you have also to develop a scripts that linux-ha cluster will use
in order to know if the service is working.
We adopted this solution with the help of a SAN attached with fiber
channell (this assure us that only one node can be attached to
the common storage) and all is working fine.
Regards
Gaetano Mendola
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mendola@bigfoot.com, chx@mail.tvnet.hu
Subject: Re: replication and linux-ha?
In-Reply-To: <410925D6.5040307@bigfoot.com>
References: <200472316751.883245@wood> <410925D6.5040307@bigfoot.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox