Postgresql logical replication pglogical monitoring - ghdrako/doc_snipets GitHub Wiki

Funkcja show_subscription_status zawiera connection string z haslem dlatego zostala stworzona safe_show_subscription_status ktora ma ograniczone pola wymagane do monitoringu

Za pomocą replication_user:
CREATE or replace FUNCTION zabbix.safe_show_subscription_status()
RETURNS TABLE(subscription_name text, status text, provider_node text) 
AS $$
BEGIN
    RETURN QUERY
    SELECT s.subscription_name, s.status, s.provider_node
    FROM pglogical.show_subscription_status() s; -- alias dla rozróżnienia
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;

GRANT EXECUTE ON FUNCTION zabbix.safe_show_subscription_status() TO zabbix;

User Zabbix:
Select * from zabbix.safe_show_subscription_status(); dziala
Select * from pglogical.show_subscription_status(); blad
⚠️ **GitHub.com Fallback** ⚠️