From: | Jov <amutu(at)amutu(dot)com> |
---|---|
To: | Ash Damle <ash(at)medgle(dot)com> |
Cc: | Amit Langote <amitlangote09(at)gmail(dot)com>, 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 03:13:21 |
Message-ID: | CADyrUxNfF1Jzdx1pjYu5orOAaspW5GRq-0XwVRoxicT8eR=9ZA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
flashback in postgresql:
http://blog.163.com/digoal(at)126/blog/static/163877040201251911813661/
make a backup before try the method
2013/5/27 Ash Damle <ash(at)medgle(dot)com>
> I don't know if I have PITR on.. how can I check?
>
> Have a backup buts it from a little while ago.. currently pulling it up on
> another machine and then will extract that data, but its not 100% current
> ... :(
>
> Ash
>
>
> On Sun, May 26, 2013 at 7:36 PM, Amit Langote <amitlangote09(at)gmail(dot)com>wrote:
>
>> 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
>>
>
>
--
Jov
blog: http:amutu.com/blog <http://amutu.com/blog>
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2013-05-27 03:28:21 | Re: Human readable or full text of xlog (pg_xlog) for vs 9.2 |
Previous Message | Ash Damle | 2013-05-27 03:10:27 | Re: Human readable or full text of xlog (pg_xlog) for vs 9.2 |