Get data back after drop Command

Started by Adarsh Sharmaover 14 years ago2 messagesgeneral
Jump to latest
#1Adarsh Sharma
adarsh.sharma@orkash.com

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

Attachments:

dir.txttext/plain; name=dir.txtDownload
#2John R Pierce
pierce@hogranch.com
In reply to: Adarsh Sharma (#1)
Re: Get data back after drop Command

On 08/28/11 9:33 PM, Adarsh Sharma wrote:

Today by mistake I issued a drop table statement in Postgresql database.
Now is it possible to get that data back through WAL.

when's your last full backup from?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast