prevent_pgbasebackup_from_becoming_sync_standby_v1.patch

application/octet-stream

Filename: prevent_pgbasebackup_from_becoming_sync_standby_v1.patch

Type: application/octet-stream

Part: 0

Message: Re: pg_basebackup blocking all queries with horrible performance

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →

Format: context

Series: patch v1

File	+	−
src/backend/replication/syncrep.c	1	0

*** a/src/backend/replication/syncrep.c
--- b/src/backend/replication/syncrep.c
***************
*** 397,402 **** SyncRepReleaseWaiters(void)
--- 397,403 ----
  		volatile WalSnd *walsnd = &walsndctl->walsnds[i];
  
  		if (walsnd->pid != 0 &&
+ 			walsnd->state == WALSNDSTATE_STREAMING &&
  			walsnd->sync_standby_priority > 0 &&
  			(priority == 0 ||
  			 priority > walsnd->sync_standby_priority))