Обсуждение: How to recover after accidentally deleted and recreated some table ina db

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.