Re: [GENERAL] recovery_target_time ignored or recovery alwaysrecovers to end of WAL

2007-07-02 Thread Jason L. Buberel
Harrumph - I downloaded the latest xlogdump source, and built/installed it against my 8.2.4 source tree. When I execute it however, I am informed that all of my WAL files (either the 'active' copies in pg_xlog or the 'archived' copies in my /pgdata/archive_logs dir) appear to be malformed: $

Re: [GENERAL] recovery_target_time ignored or recovery alwaysrecovers to end of WAL

2007-07-02 Thread Tom Lane
"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Sun, 2007-07-01 at 21:41 -0700, Jason L. Buberel wrote: >> I am trying to learn/practice the administrative steps that would need >> to be taken in a 'fat finger' scenario, and I am running into problems. > Your example transactions are so large tha

Re: [GENERAL] recovery_target_time ignored or recovery alwaysrecovers to end of WAL

2007-07-02 Thread Jason L. Buberel
Simon, Thanks for the tip. I had assumed that so long as I set 'recovery_target_time' to a value that occurred before the 'fatal commit' and set the 'inclusive' flag to false that I would be able to return to just before the deletion occurred. I'll play with it a bit more and see. I just wan

Re: [GENERAL] recovery_target_time ignored or recovery alwaysrecovers to end of WAL

2007-07-02 Thread Simon Riggs
On Sun, 2007-07-01 at 21:41 -0700, Jason L. Buberel wrote: > I am trying to learn/practice the administrative steps that would need > to be taken in a 'fat finger' scenario, and I am running into problems. > I am trying to use 'recovery.conf' to set the database state to about 15 > minutes ago i