From: Samed YILDIRIM <samed@reddoc.net>
To: Rikardo Tinauer <rikardo.tinauer@eba.si>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Recovery of corrupted database
Date: Wed, 19 Jul 2017 19:01:34 +0300
Message-ID: <8831500480094@web39g.yandex.ru> (raw)
In-Reply-To: <155A6581-E109-4FAC-B59B-ECDC09BD92AB@eba.si>
References: <155A6581-E109-4FAC-B59B-ECDC09BD92AB@eba.si>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<div>Hi Rikardo,</div><div> </div><div>I assume that you do not have any base backup, archive or replicated Postgres.</div><div> </div><div>Which Postgres version do you use? What is your operating system? Is It x64?</div><div> </div><div>Best regards.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>19.07.2017, 18:20, "Rikardo Tinauer" <rikardo.tinauer@eba.si>:</div><blockquote type="cite"><div>Our client got virus on database server encrypting the database. They paid and got files decrypted but database wasn’t able to start.<div> </div><div>We got the following error:</div><div><div><span>2017-07-19 10</span>:31:11 CEST LOG: database system was shut down in recovery at <span>2017-07-19 10</span>:29:00 CEST</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: invalid magic number B549 in log segment <span>000000010000002</span>E<span>00000015</span>, offset 0</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: invalid primary checkpoint record</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: invalid magic number B549 in log segment <span>000000010000002</span>E<span>00000015</span>, offset 0</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: invalid secondary checkpoint record</div><div><span>2017-07-19 10</span>:31:11 CEST PANIC: could not locate a valid checkpoint record</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: shutdown at recovery target</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: shutting down</div><div><span>2017-07-19 10</span>:31:11 CEST LOG: database system is shut down</div></div><div> <div> </div><div>We got past that with executing the “pg_resetxlog -f DATADIR” command.</div><div> </div><div>Now database starts but we cannot connect to it, we get the following error: </div><div><span>2017-07-19 14</span>:11:05 CEST ERROR: invalid page in block 0 of relation global/12369</div><div> </div><div>Can anyone help?</div><div> <div><div style="color:rgb(0,0,0);text-align:start;text-transform:none;white-space:normal;"><div><div style="color:rgb(0,0,0);font-family:"Arial Unicode MS";font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;text-align:start;text-transform:none;white-space:normal;">Lp, </div><div style="color:rgb(0,0,0);font-family:"Arial Unicode MS";font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;text-align:start;text-transform:none;white-space:normal;">Rikardo Tinauer</div><div style="color:rgb(0,0,0);font-family:"Arial Unicode MS";font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;text-align:start;text-transform:none;white-space:normal;">----------------------------------------------------------<br />EBA, d.o.o., Ljubljana<br />Litostrojska 40, SI-1000 Ljubljana<br />Tel: <span>+386 (0)590 98 890</span><br />Email: <a href="mailto:rikardo.tinauer@eba.si">rikardo.tinauer@eba.si</a><br />Web: <a href="http://www.ebadms.com/">http://www.ebadms.com</a><br />-----------------------------------------------------------</div></div></div></div></div></div></div></blockquote>
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, rikardo.tinauer@eba.si
Subject: Re: Recovery of corrupted database
In-Reply-To: <8831500480094@web39g.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