Re: Human readable or full text of xlog (pg_xlog) for vs 9.2

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Ash Damle <ash(at)medgle(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Human readable or full text of xlog (pg_xlog) for vs 9.2
Date: 2013-05-27 02:36:17
Message-ID: CA+HiwqFUVm7iAka9nqoK8ME55=yhRtt7-CORaVHZJ0ToH_evrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 27, 2013 at 11:27 AM, Ash Damle <ash(at)medgle(dot)com> wrote:
> Hello. I have some data that was accidently deleted.
> I have not done a vacuum etc.
>
> I know the raw text of the data should be in the xlog file.
>
> However when using xlogdump of pg_filedump I am not able to get a complete
> non compressed version of the data. Is the xlog compressed in a standard way
> that I can "uncompress" it or is there a simple way to convert it over.
>
> Thanks so much.
>
> Any suggestions would be very very much appreciated.
>

Have you been taking backups? Or do you have a backup you could
restore to using PITR?

--
Amit Langote

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ash Damle 2013-05-27 02:39:10 Re: Human readable or full text of xlog (pg_xlog) for vs 9.2
Previous Message Ash Damle 2013-05-27 02:27:09 Human readable or full text of xlog (pg_xlog) for vs 9.2