Roberto Fichera
2018-07-07 11:56:54 UTC
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.
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.