Skip site navigation (1) Skip section navigation (2)

Re: Documentation on PITR still scarce

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Documentation on PITR still scarce
Date: 2004-11-29 02:20:40
Message-ID: 200411290220.iAT2Kef05919@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Is this a TODO?

---------------------------------------------------------------------------

Greg Stark wrote:
> 
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> 
> > I suppose it might be useful to have some kind of "suspended animation"
> > behavior where you could bring up a backend and look at the database in
> > a strict read-only fashion, not really executing transactions at all,
> > just to see what you had.  Then you could end the recovery and go to
> > normal operations, or allow the recovery to proceed further if you
> > decided this wasn't where you wanted to be yet.  However that would
> > require a great deal of mechanism we haven't got (yet).  In particular
> > there is no such thing as strict read-only examination of the database.
> 
> That would be a great thing to have one day for other reasons aside from the
> ability to test out a recovered database. It makes warm standby databases much
> more useful.
> 
> A warm standby is when you keep a second machine constantly up to date by
> applying the archived PITR logs as soon as they come off your server. You're
> ready to switch over at the drop of a hat and don't have to go through the
> whole recovery process, you just switch the database from recovery mode to
> active mode and make it your primary database. But in the until then the
> backup hardware languishes, completely useless.
> 
> Oracle has had a feature for a long time that you can actually open the
> standby database in a strict read-only mode and run queries. This is great for
> a data warehouse situation where you want to run long batch jobs against
> recent data.
> 
> -- 
> greg
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-11-29 02:29:45
Subject: Re: Auto Vacuum
Previous:From: Russell SmithDate: 2004-11-29 02:19:41
Subject: Auto Vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group