pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Jesper Krogh <jesper@krogh.cc>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL PITR - more doubts
Date: Mon, 12 Jul 2010 13:38:29 +0200
Message-ID: <4C3AFEB5.8000606@krogh.cc> (raw)
In-Reply-To: <OFC2981E2C.FBD7D986-ON6525775E.003DEF04-6525775E.003E99D3@ibsplc.com>
References: <OFAF74413B.3F23C236-ON6525775B.0033D73A-6525775B.0035CD1F@ibsplc.com>
	<AANLkTinELWs84rEou9PMt7ii6xhRRK-NUkeHXBBPle5T@mail.gmail.com>
	<OF66E87B1A.0F4F4C24-ON6525775E.002E098E-6525775E.002EB698@ibsplc.com>
	<AANLkTikWa9tez_Oom3D0yNZsseTeZAUH4E4k-w1rMvEF@mail.gmail.com>
	<OFC2981E2C.FBD7D986-ON6525775E.003DEF04-6525775E.003E99D3@ibsplc.com>

On 2010-07-12 13:23, Jayadevan M wrote:
> Hello all,
> One doubt about how PostgreSQL PITR works. Let us say I have all the
> archived WALs for the past week with
> archive_command = 'cp -i %p /home/postgres/archive/%f</dev/null'
> I took a base backup last night. If I try to recover the server today
> after
> copying the base backup from yesterday and providing
> restore_command = 'cp /home/postgres/archive/%f %p'
> does PostgreSQL go through all the past week's archived WALS or
> it can figure out that the base backup is from yesterday, so skip
> a large number of archived WALs and start only from file xxx ?
>    

Yes, It starts out form "where it needs to". Assuming you
did a pg_start_backup() before you did your base backup?

-- 
Jesper

view thread (4+ messages)  latest in thread

Message-ID: <4C3AFEB5.8000606@krogh.cc>
Permalink:  ../4C3AFEB5.8000606@krogh.cc/
Also on:    postgresql.org/message-id/4C3AFEB5.8000606@krogh.cc

copy link · copy postgr.es

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-performance@postgresql.org
  Cc: jesper@krogh.cc
  Subject: Re: PostgreSQL PITR - more doubts
  In-Reply-To: <4C3AFEB5.8000606@krogh.cc>

* 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