Postgres Dropped DB have recovered files how to restore - Mailing list pgsql-general

From lifetronics
Subject Postgres Dropped DB have recovered files how to restore
Date
Msg-id 1465071651879-5906468.post@n5.nabble.com
Whole thread Raw
Responses Re: Postgres Dropped DB have recovered files how to restore
Re: Postgres Dropped DB have recovered files how to restore
List 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.


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: postgres_fdw and Kerberos authentication
Next
From: Bryan Henderson
Date:
Subject: Why threads every 30 seconds?