Get data back after drop Command

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Get data back after drop Command
Date: 2011-08-29 04:33:27
Message-ID: 4E5B1697.2040207@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

Today by mistake I issued a drop table statement in Postgresql database.
Now is it possible to get that data back through WAL.
My PostgresPLus Version : 8.4
OS : Linux ( CentOs )

My postgresql.conf parameters are :

# WRITE AHEAD LOG
#------------------------------------------------------------------------------

# - Settings -

fsync = on
synchronous_commit = on
wal_sync_method = fsync

full_page_writes = on
wal_buffers = 64kB
wal_writer_delay = 200ms
commit_delay = 0
commit_siblings = 5
checkpoint_segments = 32
checkpoint_timeout = 5min
checkpoint_completion_target = 0.5
checkpoint_warning = 30s
archive_mode = on
archive_command = ''
archive_timeout = 0

Please let me know the steps needed to get data back or ways to do.
PFA list of files in my pg_xlog directory.

Thanks

Attachment Content-Type Size
dir.txt text/plain 5.5 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-08-29 04:42:00 Re: Get data back after drop Command
Previous Message Greg Smith 2011-08-29 03:00:35 Re: Whether the function exists a in pgsql table or not?