Add WAL replay state support to PostgreSQLInstance interface

Introduce wal_replay_state() (and corresponding SQL query to report whether WAL recovery is (un)paused.

First step for #487