Update check to support older pg versions

jmckulk · jmckulk · commit 7db3223f1a0a · 2022-03-29T17:02:21.000-04:00
The `primary_conninfo` setting is not available in Postgres Versions 10
and 11. This change updates the test to use a more general check that
works in all versions
diff --git a/testing/kuttl/e2e/pgbackrest-restore/17--check-replication.yaml b/testing/kuttl/e2e/pgbackrest-restore/17--check-replication.yaml
@@ -16,7 +16,7 @@ commands:
           --file=- <<'SQL'
         DO $$
         BEGIN
-          ASSERT pg_is_in_recovery(), 'expected replica';
-          ASSERT current_setting('primary_conninfo') <> '', 'expected streaming';
+          PERFORM * FROM pg_stat_wal_receiver WHERE status = 'streaming';
+          ASSERT FOUND, 'expected streaming replication';
         END $$
       SQL
