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.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to