Postgres Dropped DB have recovered files how to restore

From: lifetronics <lifetronics(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Dropped DB have recovered files how to restore
Date: 2016-06-04 20:20:51
Message-ID: 1465071651879-5906468.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This morning I accidently deleted my database for my OpenERP accounting. I
did not have a good backup system setup so I was unable to do a system
restore. i did manage to recover the files the drop command removed but I
dont know how to get the DB back into postgres? Can anyone help me with
this. I realy need this db to be restored otherwise I am screwed.

These are the folders I recovered(i think my db was in the \base\19456
folder):

C:\Program Files (x86)\OpenERP
7.0-20141104-021038\PostgreSQL\data\base\19456\ *

C:\Program Files (x86)\OpenERP
7.0-20141104-021038\PostgreSQL\data\base\19456\ *

C:\Program Files (x86)\OpenERP
7.0-20141104-021038\PostgreSQL\data\base\311296

C:\Program Files (x86)\OpenERP
7.0-20141104-021038\PostgreSQL\data\global\pg_internal.init\ *

C:\Program Files (x86)\OpenERP
7.0-20141104-021038\PostgreSQL\data\pg_stat_tmp\ *

I am running Windows Server 2012 R2 and postgres 9.3. Any help wil be much
apreciated I am kind of desperate.

--
View this message in context: http://postgresql.nabble.com/Postgres-Dropped-DB-have-recovered-files-how-to-restore-tp5906468.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Beverley 2016-06-04 23:36:44 Re: Actual rows significantly more than estimated during many joins
Previous Message Tom Lane 2016-06-04 19:49:13 Re: [pg_trgm] Making similarity(?, ?) < ? use an index