S
S
SayZombie2018-02-23 00:42:32
PostgreSQL
SayZombie, 2018-02-23 00:42:32

Is it possible to restore postgree database data?

Good afternoon!
Faced such a problem - On the windows server, the virus was eating files from the Postgre\base folder. All folders with bases are encrypted, but I have a file backup of the base folder. Will it help restore the bases? is there any chance or way? If you just put the database folders in the old place, will it help?
Backups were made, but you can’t get them, there is another story.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2018-02-23
@SayZombie

postgresql has only one directory - data_directory (aka PGDATA). To work, you need a consistent copy of the entire directory, including the contents of all symlinks.
You can tinker with pg_filedump , but better get a backup.

S
SayZombie, 2018-02-23
@SayZombie

I changed all the data and now there are errors ERROR connecting to server: FATAL: MultiXactId 1 has not been created yet -- apparent wraparound

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question