We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent87a0491 commitef89ed5Copy full SHA for ef89ed5
testgres/pubsub.py
@@ -186,19 +186,17 @@ def catchup(self, username=None):
186
Args:
187
username: remote node's user name.
188
"""
189
-
190
try:
191
-pub_lsn=pub.node.execute(query="select pg_current_wal_lsn()::text from pg_catalog.pg_stat_replication",
192
-dbname=None,
193
-username=None)# yapf: disable
+pub_lsn=self.pub.node.execute(query="select pg_current_wal_lsn()",
+dbname=None,
+username=None)[0][0]# yapf: disable
194
# create dummy xact
195
-pub.node.execute(query="select txid_current()",dbname=None,username=None)
+self.pub.node.execute(query="select txid_current()",dbname=None,username=None)
196
query="""
197
- select{} - replay_lsn <= 0
+ select'{}'::pg_lsn - replay_lsn <= 0
198
from pg_catalog.pg_stat_replication where application_name = '{}'
199
""".format(pub_lsn,self.name)
200
201
202
# wait until this LSN reaches subscriber
203
self.pub.node.poll_query_until(
204
query=query,