How to monitor recovery on Windows?

Поиск
Список
Период
Сортировка
От Doug Gorley
Тема How to monitor recovery on Windows?
Дата
Msg-id CAKUhaRuqjifwByR1uqxXzp3v_fd9eT4hFtuheMoy4BA9+XGg-Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
This weekend, we're planning to move a production cluster to a new server.  Rather than a full dump-and-restore, I want to use a base backup from last night, have the server replay the WAL files up to the time we shutdown the old server, and go from there.  Both servers are Windows.

I've never done a recovery from WAL files before, but it sounds simple enough.  One thing I'm unsure of though: how can I monitor the progress of the recovery?  Will the WAL files themselves change or disappear?  Will progress reports end up in the PostgreSQL logs?  Something else entirely?

Thanks,
--
Doug Gorley | doug@gorley.ca

В списке pgsql-general по дате отправления:

Предыдущее
От: Yang Zhang
Дата:
Сообщение: Re: "Unlogged indexes"
Следующее
От: mark_r
Дата:
Сообщение: Re: Simple, free PG GUI/query tool wanted