Re: PostgreSQL PITR - more doubts

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jayadevan M" <Jayadevan(dot)Maymala(at)ibsplc(dot)com>, "Jesper Krogh" <jesper(at)krogh(dot)cc>
Cc: <pgsql-performance(at)postgresql(dot)org>, <pgsql-performance-owner(at)postgresql(dot)org>
Subject: Re: PostgreSQL PITR - more doubts
Date: 2010-07-12 12:28:40
Message-ID: 4C3AC42802000025000333E6@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com> wrote:

>> Yes, It starts out form "where it needs to". Assuming you
>> did a pg_start_backup() before you did your base backup?
>
> Thanks. I did.
> It uses files like 0000000B00000000000000D9.00000020.backupto get
> the necessary information?

Yeah, since it's a text file, you can easily have a look at what is
stored there. It's based on when pg_start_backup and pg_stop_backup
were run.

-Kevin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andras Fabian 2010-07-12 13:03:49 Re: PG_DUMP very slow because of STDOUT ??
Previous Message Thom Brown 2010-07-12 12:11:11 PostgreSQL 9.0 beta 3 release announcement

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-07-12 12:41:36 Re: Pooling in Core WAS: Need help in performance tuning.
Previous Message Atul.Goel 2010-07-12 12:23:40 Re: now() gives same time within the session