Postgres Dropped DB have recovered files how to restore

Поиск
Список
Период
Сортировка
От lifetronics
Тема Postgres Dropped DB have recovered files how to restore
Дата
Msg-id 1465071651879-5906468.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Postgres Dropped DB have recovered files how to restore  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Postgres Dropped DB have recovered files how to restore  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: postgres_fdw and Kerberos authentication
Следующее
От: Bryan Henderson
Дата:
Сообщение: Why threads every 30 seconds?