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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.