Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w61xO-003sSo-32 for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 07:50:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w61xN-008E8w-0l for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 07:50:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w61xM-008E8o-33 for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 07:50:13 +0000 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w61xK-00000001RNG-2fPZ for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 07:50:12 +0000 Received: by mail-lj1-x233.google.com with SMTP id 38308e7fff4ca-38a43f1f978so15461001fa.3 for ; Fri, 27 Mar 2026 00:50:10 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774597810; cv=none; d=google.com; s=arc-20240605; b=epRBNxAdgCk86nkkZgOfswGjXDQSzfCk0o168z7UumV9mJiyfsEWhu1Y7pnsCyX2SJ BOSupueDWZdGV0rVI4QhBO8lmjVMWZ+QWl9NPE7tVcVNQcxRh1piFsPXTqO4jbX/RFVd Ei/cRItX5NU0H2zSzeoMgbnV1f7K6Yd8VUrafoh40oC5CLmQogegW6fPOdtFqJoLu0FX veAEJ9LoHAxhJ1ArkBCUjY6bT176Q6dwMvw47pguIe0dgpd/E7afDtU7578gZC/ofCgl UKPpg7Ja8WZpIpjq61cWbNKNMvMsmWs+34XVSPu9HDMDb0ypX6P7kzGmNh/fjYuKxIRI Y3Sw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=nf8DY9RZPypF3W8/b9QqezaUMmPKM3opQPikQ/f9F84=; fh=BRWJzabkBcwe1wRwsHfsB8vXPAxg7HRY4nZ2psl3heo=; b=QaAF6Gu0yhMmhG8KKxiwbU9L/qpuwd/KI53jJHPHaUmBb9VCAj326pzULekooFeXgU htA7ddpo/3N6mJAN+jLvJTRAjpjYjKJz4GRR0B0N5O9/ieMjW2VWe646vGL9lkuLC07t ShA7CYU9iGIA+0E+dXHyw7DtoIkaOev217d5RPXYsx1gmYX9Gz3oiKEaybYF/mJA6a6l 75+4H1I4tKlro6gnPtxQ9eXNpzqb9dbiEE5cWexlOZPaK/17fQ5DHPzwY1UlTNGpywMA v+n0u0IrRan3B2QIULb4ealsV1+P2lxpM6ELIiMYV3uNuwdpRzKN5DLne52/jb+Ow0YT rjXQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774597810; x=1775202610; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=nf8DY9RZPypF3W8/b9QqezaUMmPKM3opQPikQ/f9F84=; b=muzu7kdG2r+IE89v2clpWwb+mcVMw/jFFbTd3LWFR+nB46Szg+YKj6Ks69KYo6J1H8 HuTEYwCe1ww93kTLc+AlEL7nW41YcB6QOvkZXn/ZpYWfWCm3TlOVWD5pLU+4kGYUHLPC /eHEitCNCNi+TMbqWlKVpIZGAkbuQwmVYK1GHkleWnUcTLzq8Ls58OYC+8qF7tV80ARS Ls45ROqT4MWIzXDmyh5TxlpQu84uyPlmjsQYX/oH6+ppxhDlgkOm7u8wy/txHBhtPZYt 8RiuOKlU2xUnh+7CU0HiQclcF8H8JFxKspFmkaCMvQP5+IiuvsG10Ik6GrqlBHSaXen+ Wb1g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774597810; x=1775202610; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=nf8DY9RZPypF3W8/b9QqezaUMmPKM3opQPikQ/f9F84=; b=TvfZt7x6IlD1EX94esyQcNmevz4dOw2bW/YCbrUqjGO6r2Bsyhz0Iej36MYMzP3C1a QMjTFYkNzZZK0dmjriGaX0IxCa2sAdYwGAU5AVA3jgX+ZeIKhjNRmH4xhFtbnicOuvaQ TMyxM5sYL0nB5OocKEub5kCKio2VdR7qCubqy/fic7JVtFAhs7tS3oYeOZ4hCmGaOQi5 NZbedUPcsamAnGrio0tn/El5pjRSWmAklN4MSX8lzgSe9/fVe27u+78GF7BJ140z94JQ iBCMI+G28Eb8xDY21n7wFlJ8U15D6FwQF9qzoXgAWIZQ7RQ7XBXwkK64PKHRtik8BgNy PAaQ== X-Forwarded-Encrypted: i=1; AJvYcCWpsBABoXeGF0+ibQow1r4FVVNKdFkORdpNz+5Rt1IVpDK3X3s3j1Dh4fNMNeueSE1Xtil3SzidoMB4TT3W@lists.postgresql.org X-Gm-Message-State: AOJu0Yxe+bBhFc0bcaZpHL8zs1QEeApKx4c9X960ZN34ObxKjI5IzeEc +NUr8LR7/ielPruGTwjEwNisyT0Xh0i9X+n9af7nIwiBzN6w1+F5H8RQRfnyNdsbdp6UdqkLv42 RZfbcaqbCmwA/rxrXgSaxtYz3BPomXhI= X-Gm-Gg: ATEYQzxOCo+rnbsDcTiVm+00/iYRzVb6bEGQr9mj3qlw30TLVOeRoguo+GMHE/exp5c dB5ww1KqtQeJI0q40s70tKy5t/oue6dX1/cegIDFjn+aAQBzo+S0kACpua/ZJ0uU5dAfaUmohZA SkJObhgSm2S0hh1TFeOk+BHaERAheyk4zR84ff/FA3yBDEVrfz1smZC01/jpNL7NkeJT6zk6hZT Di5OWoPjaDNLV8qmAiLOpHBROOuVkL14xPbqesoQ+kyFOAWhaJADuM/RDk4ANNBZ9Bo0QOA/L28 tNrFdx9BUBMny3ML9MK4HCMYAUqas/ej2fRtMtRLJQ== X-Received: by 2002:a2e:a10f:0:b0:38a:3208:8cc4 with SMTP id 38308e7fff4ca-38c732757damr5254461fa.25.1774597809485; Fri, 27 Mar 2026 00:50:09 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Fri, 27 Mar 2026 13:19:58 +0530 X-Gm-Features: AQROBzAS4zynwLQpUlsdIGuPTtTFwJ2Hq-injfZcpUPVSmN5gb5Pd38_u0qTDwA Message-ID: Subject: Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion? To: Nisha Moond Cc: shveta malik , Fujii Masao , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 27, 2026 at 10:27=E2=80=AFAM Nisha Moond wrote: > > On Fri, Mar 27, 2026 at 9:28=E2=80=AFAM shveta malik wrote: > > > > In ProcessSlotSyncInterrupts(), now we don't need the below logic right= ? > > > > if (SlotSyncCtx->stopSignaled) > > { > > if (AmLogicalSlotSyncWorkerProcess()) > > { > > ... > > proc_exit(0); > > } > > else > > { > > /* > > * For the backend executing SQL function > > * pg_sync_replication_slots(). > > */ > > ereport(ERROR, > > errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE), > > errmsg("replication slot synchronization will stop > > because promotion is triggered")); > > } > > } > > > > Right. Attached patch with the suggested changes. > After this change, why do we need to invoke ProcessSlotSyncInterrupts() twice in SyncReplicationSlots? --=20 With Regards, Amit Kapila.