<div>Hi Ertan,</div><div> </div><div>Most probably, It will work by copying your old data directory to a new identical PostgreSQL server's data directory. But, you should be sure that you have copied your data directory correctly, not only base directory, etc.</div><div> </div><div>1. Install an identical PostgreSQL server</div><div>2. Copy your old data directory to your new installation. Please do not move, copy them. Be sure that you have always a backup without any modification of your failed server.</div><div>3. Check folders' and files' permissions. As I remember, in Windows PostgreSQL works with Network Service user/permissions. But I'm not sure.</div><div>4. Check your logs before starting PostgreSQL Server</div><div>5. If everything is ok, delete postmaster.pid if exists.</div><div>6. Start your PostgreSQL server and follow your logs. You may need to start with recovery.conf.</div><div> </div><div>Best regards.</div><div> </div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>03.04.2017, 23:06, "Ertan Küçükoğlu" <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>:</div><blockquote type="cite"><p>Hi All,<br /><br />One of my test systems had electricity problem and operating system is not<br />booting now. I can recover data by connecting that HDD to another computer<br />as a USB disc. I confirm that I did a file copy complete data directory of<br />several GB in size just fine. I have no idea about their structural<br />integrity though.<br /><br />Since this computer was used for tests I did not setup any backup plan on<br />it. However, some of my colleagues seems to have some important database<br />structure *and* data saved in that system. Of course, I learn that after<br />disaster happens, but that's another story.<br /><br />* There was only one database on the server.<br />* No replication of any kind was setup. Server was a standalone.<br />* Auto vacuum setting was not changed after server setup, and I do not know<br />its defaults. I do know that it is was set to do auto vacuum.<br />* New data was added to database after midnight just once a day. Data to be<br />inserted was fetched over internet. If first trial fails there were<br />additional trials set for every 30 minutes for 5 hours max (10 trials<br />total). If any data insert trial is a success other trials were executed,<br />but did not insert any data.<br />* System otherwise is used for select queries. So, I am guessing that there<br />was no data inserted for several hours at the time of power outage. Do not<br />know about vacuum status or if database server was doing something else.<br /><br />My questions are;<br />- Is there a backup tool/way to have some kind of a backup from raw<br />PostgreSQL database files (data read from data directory rather than<br />database server) which can be restored on a different PostgreSQL server?<br />- If I setup a new PostgreSQL server using identical binaries as the crashed<br />one, and copy rescued data directory onto that new server data directory,<br />overwriting new system data directory when server is down. Will that work<br />assuming recovered data is structurally fine? If that method works, how can<br />I test that database files are fine and there is no problem with them?<br />- I am open to all other suggestions here.<br /><br />Thanks & regards,<br />Ertan Küçükoğlu<br /><br /><br /><br /> </p><span>--<br />Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)org</a>)<br />To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admin</a></span></blockquote>