Search Postgresql Archives

Re: Postgres Dropped DB have recovered files how to restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 have no idea if this will work

5) pg_dump everything and reload it into a new db.

Let me know how it goes. 


On 6 June 2016 at 16:57, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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 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.

This is what a complete $DATADIR for 9.3 looks like on a Linux source install:

postgres@killi:/usr/local/pgsql93/data> l
total 140
drwx------ 16 postgres users  4096 Jan 11 09:06 ./
drwxr-xr-x  7 root     root   4096 Jun 27  2013 ../
drwx------ 14 postgres users  4096 Jun  4  2015 base/
drwx------  2 postgres users  4096 Nov 18  2015 global/
drwx------  2 postgres users  4096 Jun 27  2013 pg_clog/
-rw-------  1 postgres users  4476 Jun 27  2013 pg_hba.conf
-rw-------  1 postgres users  1636 Jun 27  2013 pg_ident.conf
drwxr-xr-x  3 postgres users 36864 Jan 11 08:42 pg_log/
drwx------  4 postgres users  4096 Jun 27  2013 pg_multixact/
drwx------  2 postgres users  4096 Jan 11 08:42 pg_notify/
drwx------  2 postgres users  4096 Jun 27  2013 pg_serial/
drwx------  2 postgres users  4096 Jun 27  2013 pg_snapshots/
drwx------  2 postgres users  4096 Jan 11 09:06 pg_stat/
drwx------  2 postgres users  4096 Jan 11 09:06 pg_stat_tmp/
drwx------  2 postgres users  4096 Apr 26  2015 pg_subtrans/
drwx------  2 postgres users  4096 Feb 23  2015 pg_tblspc/
drwx------  2 postgres users  4096 Jun 27  2013 pg_twophase/
-rw-------  1 postgres users     4 Jun 27  2013 PG_VERSION
drwx------  3 postgres users  4096 Jun  4  2015 pg_xlog/
-rw-------  1 postgres users 20329 Jan 11 09:06 postgresql.conf
-rw-------  1 postgres users    63 Jan 11 08:42 postmaster.opts


So if what you show is everything then you are short some important directories.





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




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux