pgsql: Fix notify() and remove unnecessary checkpoint

- properly call control_slave_status() on notify
- remove unnecessary CHECKPOINT