Search Postgresql Archives

Re: [plncek2@xxxxxxxxx: Can I safe my Data?]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx


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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux