On Tue, Apr 16, 2019 at 10:10 PM Florian Rädler
<Florian.Raedler(a)deutschebahn.com> wrote:
Hi,
is it possible to restore an engine from dump file?
Define "restore an engine" and "dump file".
Assuming "restore an engine" means "Install a fresh OS+engine and make
it behave like an old one", and "dump file" being a pg_dump dump file,
the answer is "not easily, and not fully". You will have to do
something like:
1. Install OS+engine
2. Manually provision PG (init, create user/db, etc)
3. Restore your dump (pg_restore or psql, depending on format). Use
the user you created, not postgres, for restoring - this will have
much better chances to get permissions right
4. Run engine-setup and provide it the credentials of the database you restored
It should mostly work, and I heard about people doing that, although
didn't try this myself.
Notably, you will have to reinstall all your hosts (move to
maintenance, reinstall).
If you have also a backup of /etc, that's a different case. Then, you
can selectively restore files there before engine-setup. To see a list
of the files you should restore, check the source of the engine-backup
script - it has an internal variable called 'BACKUP_PATHS'.
Good luck and best regards,
--
Didi