From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Faber J. Fedor <faber@linuxnj.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Warm/hot backup server question
Date: Sun, 7 Oct 2007 22:07:00 -0500
Message-ID: <dcc563d10710072007j36bd96dbn80c8ee4aee71b688@mail.gmail.com> (raw)
In-Reply-To: <26060.1191807773@sss.pgh.pa.us>
References: <20071007202255.GB30292@neptune.faber.nom>
<26060.1191807773@sss.pgh.pa.us>
On 10/7/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Faber J. Fedor" <faber@linuxnj.com> writes:
> > I've been given the job of creating a hot/warm backup server
> > for a live Postgresql server. The problem is two-fold: 1) it's version
> > 7.4.9 and an upgrade is not feasible at this time and b) there are
> > multiple instances of postgresql running on the box; not multiple
> > databases, multiple *servers*, each listening on a different port (it
> > was a business requirement from what I've been told).
>
> If they won't let you update to 7.4.18 (the current release in that
> branch), you would be best advised to resign at once, before you get
> blamed for the train wreck that is inevitably in this system's future.
> 7.4.9 is two years old, and I count at least six fixes since then for
> data-loss bugs of the *will*-bite-you-eventually type; plus a couple
> more that you might be at risk for depending on which features you use.
I agree. Although I'd set up your new job first if possible.
I also agree that Slony is your best bet. Note only the older
versions of slony run on 7.4, so make sure you download the version of
slony that works with 7.4. I think it's 1.0, could be 1.1 or so.
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: scott.marlowe@gmail.com, tgl@sss.pgh.pa.us, faber@linuxnj.com
Subject: Re: Warm/hot backup server question
In-Reply-To: <dcc563d10710072007j36bd96dbn80c8ee4aee71b688@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