Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-07 Thread Alvaro Herrera
John R Pierce wrote: > On 6/6/2016 4:09 PM, Alvaro Herrera wrote: > >I have no idea about Windows filesystems but you may be able to > >"undelete" the files, as long as you don't touch the partition for > >anything else; search the web for "undelete ntfs". Once you undelete > >you will need to

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread John R Pierce
On 6/6/2016 4:09 PM, Alvaro Herrera wrote: I have no idea about Windows filesystems but you may be able to "undelete" the files, as long as you don't touch the partition for anything else; search the web for "undelete ntfs". Once you undelete you will need to put them back in the right places.

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread Alvaro Herrera
lifetronics wrote: > 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

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread Dave Cramer
Ok, 1) back up the file system now as it is. So you can start over when this doesn't work. 2) create an empty database again with no data, but all of the DDL. 3) figure out the names of the new database files, and copy your old ones in with the same name as the new ones 4) cross your fingers. I

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread Adrian Klaver
On 06/04/2016 01:20 PM, lifetronics wrote: 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

[GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread lifetronics
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.