From: Joshua D. Drake <jd@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Zach Bagnall <zach.bagnall@bulletinwireless.com>
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: Tue, 13 Feb 2007 19:00:31 -0800
Message-ID: <45D27B4F.4080005@commandprompt.com> (raw)
In-Reply-To: <1288.1171415555@sss.pgh.pa.us>
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>
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.
Joshua D. Drake
>
> regards, tom lane
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
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: jd@commandprompt.com, tgl@sss.pgh.pa.us, zach.bagnall@bulletinwireless.com, peter_e@gmx.net, radhika@88thstreet.com
Subject: Re: Postgresql Upgrade 7.4 to 8.2
In-Reply-To: <45D27B4F.4080005@commandprompt.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