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.
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 |