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.