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