pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
replication and linux-ha?
2+ messages / 2 participants
[nested] [flat]

* replication and linux-ha?
@ 2004-07-23 14:07 Negyesi Karoly <chx@mail.tvnet.hu>
  2004-07-29 16:29 ` Re: replication and linux-ha? Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Negyesi Karoly @ 2004-07-23 14:07 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: replication and linux-ha?
  2004-07-23 14:07 replication and linux-ha? Negyesi Karoly <chx@mail.tvnet.hu>
@ 2004-07-29 16:29 ` Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Gaetano Mendola @ 2004-07-29 16:29 UTC (permalink / raw)
  To: Negyesi Karoly <chx@mail.tvnet.hu>

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








^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-29 16:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-23 14:07 replication and linux-ha? Negyesi Karoly <chx@mail.tvnet.hu>
2004-07-29 16:29 ` Gaetano Mendola <mendola@bigfoot.com>

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