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. > archive_mode = on > archive_command = '' If you were doing Point In Time Recovery (PITR) backups, you could restore your last base backups and recover using WAL files up to just before the table was dropped: http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html#BACKUP-PITR-RECOVERY The empty archive_command suggests that you're not doing proper PITR style backups, so it appears the answer to your question is "No." There is a chance that an expert might still be able to recover some of the data. That's likely to be time-consuming and expensive, but if the table is not backed up and has sufficient value to you, it might be worth it. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
