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.
