Discussion:
How to recover after accidentally deleted and recreated some table in a db
Roberto Fichera
2018-07-07 11:56:54 UTC
Permalink
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:

[***@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.

Loading...