How to recover after accidentally deleted and recreated some table in a db

From: Roberto Fichera <kernel(at)tekno-soft(dot)it>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Cc: Roberto Fichera <robyf(at)tekno-soft(dot)it>
Subject: How to recover after accidentally deleted and recreated some table in a db
Date: 2018-07-07 11:56:54
Message-ID: 0d681217-3d92-d55f-f4dd-b8a900a01340@tekno-soft.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)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.

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Kirkwood 2018-07-08 10:08:54 Re: "postgres" is needed by initdb but was not found
Previous Message Mohammed Shahid Nawaz 2018-07-07 05:37:11 Re: "postgres" is needed by initdb but was not found