#!/bin/bash

CHECKSQL="SELECT ss.subscription_name, status, provider_node, provider_dsn FROM pglogical.subscription s, pglogical.show_subscription_status(s.sub_name) ss"
echo "$CHECKSQL" | psql -U postgres p2pvr -h firebrand
echo "$CHECKSQL" | psql -U postgres gentoobrowse -h defiant