Re: pg_xlog - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_xlog
Date
Msg-id 16424.1099512899@sss.pgh.pa.us
Whole thread Raw
In response to pg_xlog  (Reynard Hilman <reynardmh@lightsky.com>)
List pgsql-general
Reynard Hilman <reynardmh@lightsky.com> writes:
> Is there a way to translate information in pg_xlog files to a more
> readable format?
> Basically we have someone accidentally emptied a text column containing
> quite a large amount of text, and unfortunately have no backups.

No, and I don't think it would help you anyway.  pg_xlog is only
intended as short-term backup; it's unlikely to contain data that is more
than a few minutes old.

            regards, tom lane

pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: Number of months
Next
From: Jim Strickland
Date:
Subject: Re: PostgreSQL on Linux PC vs MacOS X