Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Ash Damle
Date:
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.

Cheers

Ash

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

From
Amit Langote
Date:
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

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

From
Ash Damle
Date:
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

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

From
Ash Damle
Date:
WAL was not set or archive .. 

Thus I would conclude that PITR was not activated.. correct?

Ash


On Sun, May 26, 2013 at 7:39 PM, Ash Damle <ash@medgle.com> wrote:
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


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

From
Jov
Date:
flashback in postgresql：


make a backup before try the method


2013/5/27 Ash Damle <ash@medgle.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@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




--
Jov

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

From
Amit Langote
Date:
On Mon, May 27, 2013 at 12:10 PM, Ash Damle <ash@medgle.com> wrote:
> WAL was not set or archive ..
>
> Thus I would conclude that PITR was not activated.. correct?
>

Without a WAL archive (that is, archive_mode=on with appropriate
archive_command set), you would not be able to do a PITR.
I think we would have to wait for others to reply on this thread to
point out any others means to recover your data, if any.



--
Amit Langote

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

From
Ash Damle
Date:
Sadly the flashback didn't work...do you need to do a vacuum for it to work.. I haven't...

Cheers

Ash


On Sun, May 26, 2013 at 8:28 PM, Amit Langote <amitlangote09@gmail.com> wrote:
On Mon, May 27, 2013 at 12:10 PM, Ash Damle <ash@medgle.com> wrote:
> WAL was not set or archive ..
>
> Thus I would conclude that PITR was not activated.. correct?
>

Without a WAL archive (that is, archive_mode=on with appropriate
archive_command set), you would not be able to do a PITR.
I think we would have to wait for others to reply on this thread to
point out any others means to recover your data, if any.



--
Amit Langote