Hi Rikardo,
I assume that you do not have any base backup, archive or replicated Postgres.
Which Postgres version do you use? What is your operating system? Is It x64?
Best regards.
Samed YILDIRIM
19.07.2017, 18:20, "Rikardo Tinauer" <rikardo.tinauer@xxxxxx>:
Our client got virus on database server encrypting the database. They paid and got files decrypted but database wasn’t able to start.We got the following error:2017-07-19 10:31:11 CEST LOG: database system was shut down in recovery at 2017-07-19 10:29:00 CEST2017-07-19 10:31:11 CEST LOG: invalid magic number B549 in log segment 000000010000002E00000015, offset 02017-07-19 10:31:11 CEST LOG: invalid primary checkpoint record2017-07-19 10:31:11 CEST LOG: invalid magic number B549 in log segment 000000010000002E00000015, offset 02017-07-19 10:31:11 CEST LOG: invalid secondary checkpoint record2017-07-19 10:31:11 CEST PANIC: could not locate a valid checkpoint record2017-07-19 10:31:11 CEST LOG: shutdown at recovery target2017-07-19 10:31:11 CEST LOG: shutting down2017-07-19 10:31:11 CEST LOG: database system is shut downWe got past that with executing the “pg_resetxlog -f DATADIR” command.Now database starts but we cannot connect to it, we get the following error:2017-07-19 14:11:05 CEST ERROR: invalid page in block 0 of relation global/12369Can anyone help?Lp,Rikardo Tinauer----------------------------------------------------------
EBA, d.o.o., Ljubljana
Litostrojska 40, SI-1000 Ljubljana
Tel: +386 (0)590 98 890
Email: rikardo.tinauer@xxxxxx
Web: http://www.ebadms.com
-----------------------------------------------------------
