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

Re: Point-In-Time Recovery not working

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "gais" <gais(at)alpenjodel(dot)de>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Point-In-Time Recovery not working
Date: 2011-08-26 16:50:27
Message-ID: 4E578883020000250004076B@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
gais <gais(at)alpenjodel(dot)de> wrote:
 
> I'm running a caldav server with postgresql backend. For some
> reason a user removed his agenda, I want to revert to a state
> before 20th of August in order to restore this. I have a
> configuration with archive_mode = on in postgresql.conf and a
> timeout of 24h. I have a dump from the original database and all
> WAL files from the last 18 months. I want to restore the database
> and run all WAL to restore to it's last working state.
> 
> I've tried two options based on the documentation: 
>
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
 
> option one:
 
> [code]initdb -d /var/lib/postgresql/8.3/main[/code]
 
> second option:
 
> [code]initdb -d /var/lib/postgresql/8.3/main[/code]
 
Not based very closely on the documentation.  Please read the
"Recovering using a Continuous Archive Backup" subsection closely
and follow the directions there.  In particular, initdb is not run
as part of the recovery.  If you follow the directions step by step,
you should get farther.  If you still have problems, feel free to
post again.
 
-Kevin

In response to

Responses

pgsql-admin by date

Next:From: gaisDate: 2011-08-26 22:12:15
Subject: Re: Point-In-Time Recovery not working
Previous:From: gaisDate: 2011-08-26 16:21:45
Subject: Point-In-Time Recovery not working

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