Re: [HACKERS] Preliminary PITR documentation available

2004-08-04 Thread Matthew D. Fuller
On Tue, Aug 03, 2004 at 11:27:35PM -0400 I heard the voice of
Mike Mascari, and lo! it spake thus:
> Christopher Kings-Lynne wrote:
> 
> >"The ability to restore the database to a previous point in time creates 
> >some complexities that are akin to science-fiction stories about time 
> >travel and parallel universes."
> 
> Is it science-fiction, or just relativity?

Depends on how fast you read it.


-- 
Matthew Fuller (MF4839)   |  [EMAIL PROTECTED]
Systems/Network Administrator |  http://www.over-yonder.net/~fullermd/

"The only reason I'm burning my candle at both ends, is because I
  haven't figured out how to light the middle yet"

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [HACKERS] Preliminary PITR documentation available

2004-08-03 Thread Mike Mascari
Christopher Kings-Lynne wrote:
People have been complaining (not without reason) that without any
documentation they can hardly test the new PITR code.  I have hacked
up and committed some rough docs that should be enough for testing.
They're on-line now at
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
and should within a few hours be visible at
http://developer.postgresql.org/docs/postgres/backup-online.html
(but right now the latter page contains only an introductory blurb).
I love this:
"The ability to restore the database to a previous point in time creates 
some complexities that are akin to science-fiction stories about time 
travel and parallel universes."
Is it science-fiction, or just relativity?
Mike Mascari

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] Preliminary PITR documentation available

2004-08-03 Thread markir
Certainly gave me a chuckle. Technical documentation with humour...now the
product has *everything*.

Mark

Quoting Tom Lane <[EMAIL PROTECTED]>:

> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > I love this:
>
> > "The ability to restore the database to a previous point in time creates
> > some complexities that are akin to science-fiction stories about time
> > travel and parallel universes."
>
> Well, the code *works* but I'm not entirely sure how to explain the
> feature.  These are just rough docs ... feel free to step up and do
> better ...
>
>   regards, tom lane
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>





---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] Preliminary PITR documentation available

2004-08-03 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> I love this:

> "The ability to restore the database to a previous point in time creates 
> some complexities that are akin to science-fiction stories about time 
> travel and parallel universes."

Well, the code *works* but I'm not entirely sure how to explain the
feature.  These are just rough docs ... feel free to step up and do
better ...

regards, tom lane

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [HACKERS] Preliminary PITR documentation available

2004-08-03 Thread Bruce Momjian

I thought Simon was going to give us some docs for PITR.  Did he or did
you have to write up your own?

---

Tom Lane wrote:
> People have been complaining (not without reason) that without any
> documentation they can hardly test the new PITR code.  I have hacked
> up and committed some rough docs that should be enough for testing.
> They're on-line now at
> http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
> and should within a few hours be visible at
> http://developer.postgresql.org/docs/postgres/backup-online.html
> (but right now the latter page contains only an introductory blurb).
> 
>   regards, tom lane
> 
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> 

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

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] Preliminary PITR documentation available

2004-08-03 Thread Christopher Kings-Lynne
People have been complaining (not without reason) that without any
documentation they can hardly test the new PITR code.  I have hacked
up and committed some rough docs that should be enough for testing.
They're on-line now at
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
and should within a few hours be visible at
http://developer.postgresql.org/docs/postgres/backup-online.html
(but right now the latter page contains only an introductory blurb).
I love this:
"The ability to restore the database to a previous point in time creates 
some complexities that are akin to science-fiction stories about time 
travel and parallel universes."

Awesome :)
Chris
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match


[HACKERS] Preliminary PITR documentation available

2004-08-03 Thread Tom Lane
People have been complaining (not without reason) that without any
documentation they can hardly test the new PITR code.  I have hacked
up and committed some rough docs that should be enough for testing.
They're on-line now at
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
and should within a few hours be visible at
http://developer.postgresql.org/docs/postgres/backup-online.html
(but right now the latter page contains only an introductory blurb).

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])