Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: dir.txt
Description: text/plain (5.5 KB)

Responses

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group