Обсуждение: accidentally deleted rows

You may be able to recover them, but you could make things worser if
you do not do it correctly.

http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php
http://archives.postgresql.org/pgsql-general/2006-02/msg00091.php


On 2/6/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
>  hi,
>
> i have acidentally deleted rows from a table. is it possible to recover them
>
> i have read somewhere that the source code can be modified to recover them,
> can some one tell me the way so that it can be done.
>
> Please note that i have no back up of the data, is it not possible to
> recover them thru pg_xlog?
>
> thank you
>
> regards
> Surabhi

On Sun, 2006-02-05 at 23:41, Pandurangan R S wrote:
> You may be able to recover them, but you could make things worser if
> you do not do it correctly.
>
> http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php
> http://archives.postgresql.org/pgsql-general/2006-02/msg00091.php

I was under the impression that pg_reset_xlog (I think that's how it's
spelt) could allow you to see the old tuples assuming they hadn't been
vacuumed and reused.

But of course, like those two messages make it clear, seeing deleted
tuples can cause some serious issues.  Always copy your data/base
directory to another computer and play with that copy in case something
bad happens.

Oh, and to the OP... start taking backups.