blob: 6558cf304ae360b84594e8b966cbf98e58b3b942 (
plain)
1
2
3
4
5
|
#!/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
|
