pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ewald Geschwinde <egeschwinde@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Cluster/Replication
Date: Mon, 22 Oct 2007 11:05:55 +0200
Message-ID: <cf42ed390710220205p3ff518co88f548e56a095315@mail.gmail.com> (raw)
In-Reply-To: <pan.2007.10.22.08.34.20@gmail.com>
References: <D7B69B79-A6B1-443B-AAB7-C53CA60BD874@eaglepress.com>
	<pan.2007.10.22.08.34.20@gmail.com>

On 10/22/07, cho <tobutaz@gmail.com> wrote:
>
> Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit:
>
> > We are setting up a new database system that is going to act as our
> > central database. We are planning to have a Master/Slave setup,
> > originally with one slave but there is a strong possibility of adding a
> > second slave at our second site. We could run Mulit-Master, it just
> > wasn't the original plan. (The original plan was MySQL log shipping). We
> > do not want the possibility of loosing data in the event of loosing the
> > master node so synchronous replication is preferable. We are using
> > BLOBS, so the replication has to be able to handle that. The slave we
> > want to have useable but it would be used for reporting only under
> > normal usage.
>
>
>
If you want to use synchronous replication look at the link

http://www.postgresql.at/english/downloads_e.html

this is an enhanced and tested version of pgcluster - it's open source you
can use it
it is also working on windows

-- 
Ewald Geschwinde

view thread (7+ messages)  latest in thread

Message-ID: <cf42ed390710220205p3ff518co88f548e56a095315@mail.gmail.com>
Permalink:  ../cf42ed390710220205p3ff518co88f548e56a095315@mail.gmail.com/
Also on:    postgresql.org/message-id/cf42ed390710220205p3ff518co88f548e56a095315@mail.gmail.com

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: egeschwinde@gmail.com
  Subject: Re: Cluster/Replication
  In-Reply-To: <cf42ed390710220205p3ff518co88f548e56a095315@mail.gmail.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