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

Поиск
Список
Период
Сортировка
От Ash Damle
Тема Re: Human readable or full text of xlog (pg_xlog) for vs 9.2
Дата
Msg-id CAP8vXe70y_rUWgyN5VVs09oYNLBFEpN27n+-dxp_1OuJt6iBpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Human readable or full text of xlog (pg_xlog) for vs 9.2  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Human readable or full text of xlog (pg_xlog) for vs 9.2  (Ash Damle <ash@medgle.com>)
Re: Human readable or full text of xlog (pg_xlog) for vs 9.2  (Jov <amutu@amutu.com>)
Список pgsql-general
Дерево обсуждения
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@gmail.com> wrote:
On Mon, May 27, 2013 at 11:27 AM, Ash Damle <ash@medgle.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Human readable or full text of xlog (pg_xlog) for vs 9.2
Следующее
От: Ash Damle
Дата:
Сообщение: Re: Human readable or full text of xlog (pg_xlog) for vs 9.2