Re: [plncek2@gmail.com: Can I safe my Data?]

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(dot)klaver(at)aklaver(dot)com