On Wed, 2019-01-23 at 18:58 +0100, Ivan Voras wrote:
And, the actual question: how to monitor the WAL replay process? Currently, the recovery.conf file is sitting there, with the database running, but pg processes are idle, and pg_stat_activity doesn't list anything which appears to be related to the recovery process.
The server logs each wal segment that gets processed during recovery. And you would definitely see a busy high-I/IO process applying the recovery.
It also logs when the recovery is complete. And I'm pretty sure it renames recovery.conf to recovery.done or something when it's done.