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 |
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? |