From: Samed YILDIRIM <samed@reddoc.net>
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL 9.6.1 - Windows 64bit - HDD crash due to power outage
Date: Mon, 03 Apr 2017 23:20:52 +0300
Message-ID: <544871491250852@web29j.yandex.ru> (raw)
In-Reply-To: <007b01d2acb5$7a93cb90$6fbb62b0$@1nar.com.tr>
References: <007b01d2acb5$7a93cb90$6fbb62b0$@1nar.com.tr>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<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.kucukoglu@1nar.com.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@postgresql.org">pgsql-admin@postgresql.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-admi...;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: samed@reddoc.net, ertan.kucukoglu@1nar.com.tr
Subject: Re: PostgreSQL 9.6.1 - Windows 64bit - HDD crash due to power outage
In-Reply-To: <544871491250852@web29j.yandex.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox