Re: [GENERAL] [plncek2@gmail.com: Can I safe my Data?] - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] [plncek2@gmail.com: Can I safe my Data?]
Date
Msg-id 3e81c666-5291-241e-2e4a-68a5681abafc@aklaver.com
Whole thread Raw
In response to [GENERAL] [plncek2@gmail.com: Can I safe my Data?]  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
On 05/08/2017 03:34 PM, Alvaro Herrera wrote:
>
Hello.. My name is Rian.

I have a problem, my Database attacked by ransomware virus. Some file
has encrypt. for pg_hba and postgresql.conf i have a backup, but for
some file like pg_filenode.map i dont have.

this a log when i start the postgres:

2017-05-08 10:08:17 ICT FATAL:  relation mapping file
"global/pg_filenode.map" contains invalid data

Looks like the PGDATA directory was encrypted. Unless you have a backed
up dump file that you created using pg_dump or have been archiving WAL
files you are not going to be able to reclaim the database without
getting the files unencrypted.


thanks for kindness.

postgresql-2017-05-08_100800.log

2017-05-08 10:08:07 ICT LOG:  database system was interrupted; last
known up at 2017-05-08 10:05:29 ICT
2017-05-08 10:08:07 ICT LOG:  database system was not properly shut
down; automatic recovery in progress
2017-05-08 10:08:08 ICT LOG:  record with zero length at 1B1/7F306250
2017-05-08 10:08:08 ICT LOG:  redo is not required
2017-05-08 10:08:13 ICT LOG:  database system is ready to accept connections
2017-05-08 10:08:17 ICT LOG:  autovacuum launcher started
2017-05-08 10:08:17 ICT FATAL:  relation mapping file
"global/pg_filenode.map" contains invalid data
2017-05-08 10:08:17 ICT LOG:  autovacuum launcher process (PID 816)
exited with exit code 1
2017-05-08 10:08:17 ICT LOG:  terminating any other active server processes
2017-05-08 10:08:18 ICT LOG:  all server processes terminated;
reinitializing
2017-05-08 10:08:29 ICT FATAL:  pre-existing shared memory block is
still in use
2017-05-08 10:08:29 ICT HINT:  Check if there are any old server
processes still running, and terminate them.




--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Python versus Other Languages using PostgreSQL
Next
From: Paul Hughes
Date:
Subject: Re: [GENERAL] Python versus Other Languages using PostgreSQL