From: Zach Bagnall <zach.bagnall@bulletinwireless.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org, Peter Eisentraut <peter_e@gmx.net>
Cc: radhika@88thstreet.com
Subject: Re: Postgresql Upgrade 7.4 to 8.2
Date: Wed, 14 Feb 2007 16:26:24 +1300
Message-ID: <45D28160.10309@bulletinwireless.com> (raw)
In-Reply-To: <45D27B4F.4080005@commandprompt.com>
References: <21058.63.118.86.10.1169649336.squirrel@www.88thstreet.com>
<200701241703.28901.peter_e@gmx.net>
<45B79349.7050108@commandprompt.com>
<45D23635.1070601@bulletinwireless.com>
<1288.1171415555@sss.pgh.pa.us>
<45D27B4F.4080005@commandprompt.com>
On 02/14/07 16:00, Joshua D. Drake wrote:
> Tom Lane wrote:
>> Zach Bagnall <zach.bagnall@bulletinwireless.com> writes:
>>>> Seriously though, the PITR recovery mechanism is quite mature and usable.
>>> I would say it is a good start - and progress is clearly being made. But
>>> it wont be "usable" for most serious applications until we have
>>> per-database transaction logging and backup recovery.
>
>> Don't hold your breath; that's not even on the agenda, much less
>> something that's likely to appear soon. If you need separable recovery
>> then run a different postmaster instance for each database.
>
> I would have to concur... if you need such a feature I would wonder why
> you are running multiple databases within the same cluster at all.
It's not exactly an exotic feature. Sybase has had it for as long as I
can remember, as has Informix and DB2 (I'm told).
The obvious reason for not running multiple instances is that postgresql
will know how to use the available memory most efficiently. By splitting
them up, each postmaster must be tuned and adjusted by a stupid human.
Unless you meant using a new hardware server for each database..
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: zach.bagnall@bulletinwireless.com, jd@commandprompt.com, tgl@sss.pgh.pa.us, peter_e@gmx.net, radhika@88thstreet.com
Subject: Re: Postgresql Upgrade 7.4 to 8.2
In-Reply-To: <45D28160.10309@bulletinwireless.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