How to recover after accidentally deleted and recreated some table in a db
Roberto Fichera <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Organization | TeknoSOFT |
| Message-ID | <[email protected]> |
Hi All, I've wrongly deleted some tables in my fedora postgresql v9.6.8 installation. Unfortunately the postgresql.conf was almost default untouched configuration so having wal_level=minimal. I've stopped the db immediately after realizing the problem. So now I don't really know if I can do that and how. My wish is to restore the condition at 08:41am or 09:07am. Below how my pg_xlog directory looks like: [root@crm pg_xlog]# ll total 81924 -rw------- 1 postgres postgres 16777216 Jul 7 09:21 000000010000000200000074 -rw------- 1 postgres postgres 16777216 Jul 6 15:42 000000010000000200000075 -rw------- 1 postgres postgres 16777216 Jul 6 20:34 000000010000000200000076 -rw------- 1 postgres postgres 16777216 Jul 7 08:41 000000010000000200000077 -rw------- 1 postgres postgres 16777216 Jul 7 09:07 000000010000000200000078 drwx------ 2 postgres postgres 4096 Jan 1 2018 archive_status Can anyone suggest what to do? Thanks in advance, Roberto Fichera.