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

2013-05-26 Thread Ash Damle
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 wrote: > On Mon, May 27, 2013 at 12:10 PM, Ash Damle wrote: > > WAL was not set or archive .. > > > > Thus I w

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

2013-05-26 Thread Ash Damle
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 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 u

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

2013-05-26 Thread Ash Damle
13 at 11:27 AM, Ash Damle 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 ge

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

2013-05-26 Thread Ash Damle
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 th