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

Re: Dropped table, no backup, restore from file system backup or WAL files?

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: "John T(dot) Dow" <john(at)johntdow(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Dropped table, no backup, restore from file system backup or WAL files?
Date: 2010-07-07 04:53:59
Message-ID: 4C340867.7070103@krogh.cc (view raw or flat)
Thread:
Lists: pgsql-novice
On 2010-07-07 03:24, John T. Dow wrote:
> In neither case does it restore any data.
>
> Note: for the recovery procedure, I have a BAT file that literally does nothing. The reason is that I've copied the proper WAL files into the pg_xlog directory, so there is no archiving per se.
>    
Ok, try to fix that.. as per:
24.3.3 here:
http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html

Assuming that the filesystem backup was made using 
pg_start_backup()/pg_stop_backup() it will just work.

Jesper

In response to

pgsql-novice by date

Next:From: GregDate: 2010-07-07 08:15:39
Subject: Re: Data type OIDs
Previous:From: John T. DowDate: 2010-07-07 01:24:56
Subject: Dropped table, no backup, restore from file system backup or WAL files?

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