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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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:

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:

flashback in postgresql：

http://blog.163.com/digoal@126/blog/static/163877040201251911813661/

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
blog: http:amutu.com/blog <http://amutu.com/blog&gt;

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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: