Should it be "WAL receivers" or "WAL sending targets" then - as those servers receive data from current server, not send data to it?
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menu
ActionShellExec = RestartService:net stop svcname && net start svcname
SELECT CASE WHEN pg_is_in_recovery() THEN 'YES' ELSE 'NO' END AS in_recovery, CASE WHEN count(*) > 0 THEN 'YES' ELSE 'NO' END AS is_receiver FROM pg_catalog.pg_stat_wal_receiver
42P01 ERROR: relation "pg_catalog.pg_stat_wal_receiver" does not exist