Обсуждение: [GENERAL] [plncek2@gmail.com: Can I safe my Data?]

--
Álvaro Herrera                         Developer, https://www.PostgreSQL.org/
"The problem with the facetime model is not just that it's demoralizing, but
that the people pretending to work interrupt the ones actually working."
                                                           (Paul Graham)
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

thanks for kindness.

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