From: Richard Huxton <dev@archonet.com>
To: Naomi Walker <nwalke@eldocomp.com>
Cc: GENERAL <pgsql-general@postgresql.org>
Subject: Re: Upgrade in Place
Date: Wed, 12 Nov 2008 17:36:45 +0000
Message-ID: <491B142D.5010508@archonet.com> (raw)
In-Reply-To: <491B0CF9.10700@eldocomp.com>
References: <234747.33153.qm@web52501.mail.re2.yahoo.com>
<491B0CF9.10700@eldocomp.com>
Quick tip: don't start a new thread by replying to a previous message,
it can mean your message gets missed.
Naomi Walker wrote:
> We have a very large new customer that is considering using Postgres for
> their RDBMS. The size
> of the database will be in the several terrabytes range, making
> unloading/reloading a time consuming
> and disk-eating process. This customer will be running on a Windows
> platform.
For such a large database, I would give serious thought to not running
on Windows. PostgreSQL has a much longer history on the unix side of the
fence, and a larger *nix community of users and developers. If you're
worried about support, I'm sure Red Hat, Novell or Sun would be more
than happy with the money you'd have spent on Windows licencing. There
are also several well established PostgreSQL consulting companies who
can support both the database and operating-system.
> I've been looking at the upgrade_in_place docs in pgfoundry, but it
> seems it is in the "trying to be
> revived" stage.
>
> Does anyone have newer information about the move towards upgrades-in-place?
Work is ongoing for 8.4 (to allow you to upgrade in-place to 8.5). You
have pretty much full access to all development discussions by checking
the pgsql-hackers mailing list (there's also a developers side to the
website). Search for "WIP" on the hackers list. Bear in mind that
there's no guarantee that *any* feature not yet complete will make it
into 8.4 (although there are a lot of big users who really want this
feature, so it's a strong candidate).
HTH
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, nwalke@eldocomp.com, pgsql-general@postgresql.org
Subject: Re: Upgrade in Place
In-Reply-To: <491B142D.5010508@archonet.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