Re: Postgresql Upgrade 7.4 to 8.2 - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Postgresql Upgrade 7.4 to 8.2
Date
Msg-id 45D27B4F.4080005@commandprompt.com
Whole thread Raw
In response to Re: Postgresql Upgrade 7.4 to 8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgresql Upgrade 7.4 to 8.2  (Zach Bagnall <zach.bagnall@bulletinwireless.com>)
List pgsql-admin
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/


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql Upgrade 7.4 to 8.2
Next
From: Zach Bagnall
Date:
Subject: Re: Postgresql Upgrade 7.4 to 8.2