Re: pg_xlog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: reynardh(at)lightsky(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog
Date: 2004-11-03 20:14:59
Message-ID: 16424.1099512899@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Reynard Hilman <reynardmh(at)lightsky(dot)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

In response to

  • pg_xlog at 2004-11-03 18:59:54 from Reynard Hilman

Browse pgsql-general by date

  From Date Subject
Next Message Jim Strickland 2004-11-03 21:04:03 Re: PostgreSQL on Linux PC vs MacOS X
Previous Message Franco Bruno Borghesi 2004-11-03 20:08:51 Re: Number of months