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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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