Postgres Pro
Downloads
Home   >   mailing lists

Any way to extract records from the WAL? - Mailing list pgsql-general

From Tony Caduto
Subject Any way to extract records from the WAL?
Date
Msg-id 43E287DF.3060204@amsoftwaredesign.com
Whole thread Raw
List pgsql-general
Tree view 
Hi,
I accidently deleted 2600 records.  They are not super important but I
would like to get them back.

I copied the WAL file the deletes are in and I can see the text and
dates from the records, they are all there.

Is there a way to just extract the records without going through the
whole PITR thing?  It's a test server and I was not backing it up, so
there is no dump available.

Thanks,

Tony

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Primary keys for companies and people
Next
From: Stephan Szabo
Date:
Subject: Re: question about MAKE_EXPIRED_TUPLES_VISIBLE