pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/




view thread (9+ messages)  latest in thread

Message-ID: <45D27B4F.4080005@commandprompt.com>
Permalink:  ../45D27B4F.4080005@commandprompt.com/
Also on:    postgresql.org/message-id/45D27B4F.4080005@commandprompt.com

 · 

reply

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