How to monitor recovery on Windows?

From: Doug Gorley <doug(at)gorley(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: How to monitor recovery on Windows?
Date: 2013-05-03 17:41:53
Message-ID: CAKUhaRuqjifwByR1uqxXzp3v_fd9eT4hFtuheMoy4BA9+XGg-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gorley(dot)ca

Browse pgsql-general by date

  From Date Subject
Next Message Yuriy Rusinov 2013-05-03 17:44:04 Re: SPI_execute_with_args call
Previous Message pradeep singh 2013-05-03 15:30:12 Re: Curious why planner can't handle NOT IN