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.94.2) (envelope-from ) id 1u4vUa-009WNf-Jl for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 05:39:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u4vUY-006yFR-5W for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 05:39:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4vUX-006yFJ-Rz for pgsql-hackers@lists.postgresql.org; Wed, 16 Apr 2025 05:39:22 +0000 Received: from mail-lj1-x236.google.com ([2a00:1450:4864:20::236]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4vUW-000Jno-1w for pgsql-hackers@lists.postgresql.org; Wed, 16 Apr 2025 05:39:21 +0000 Received: by mail-lj1-x236.google.com with SMTP id 38308e7fff4ca-30db1bc464dso60535731fa.0 for ; Tue, 15 Apr 2025 22:39:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744781959; x=1745386759; 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=d2gC6IrnPeZhtvS2+5pysfR1ac66DsxCS7M2B2UmNgE=; b=SfnPrDNW/5Nd+s9crnA+bzOvQZlj3lfYqGi+P+v6eTJO2dqPk1fy/9l/Ih/XBnKbwn nHOKkqwiIU8fkV/dgSbzbiMOyg28nmw51hnMpcXDGh3JI3tkl4AuNuXjPjglEN1QfhAt MJoSK9uKHLdJXndRaGzndxta6SGVh4C/atoQFuwbNctuuQMrOAROfB5K5tYBPG0WtAuz gdEm80ohgCGnrMVBgsdNmd1XkcHgqIC7R5OwqwsyhpFwlYPqA/CH49hg12Ni5kuo0Rau 2iYdUmm4qayq9Ewq8X7rlThpNhGi4M1zA0sQf3SHZNjCNSZbV6xzxeF8pe6n6ZxaW4z8 J9gA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744781959; x=1745386759; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=d2gC6IrnPeZhtvS2+5pysfR1ac66DsxCS7M2B2UmNgE=; b=av5/g1d50iEYYfpxu0yiYYmxgM2lpImh5looYVikgH2/oU4nWoC8tmnFkHKQS2ZVzC 96a/S9Tg0SG9IXdqSll2rEpjXzE1lCc9uRKj2r9AvjHpbYISmCPfxyDRB3JG4fd4mfkI rWoOkNx7/kfLMBIA3WpLv6VVe4MgA08QWifqgg00+uFAkvVkGZ3Sudgi9FYnkBJ2lp7m 3BIOAuXcw1kLWRlc5Vi1XcCj4veQT/Ev+T5ZP2/4W+xEp+rGbPxDqFZo0jGB0tKSYHQa 67HpUfYAfO3oV67isGFlu4/F3VfOtZmE/9TmDxoPoShant0lj6XbcGw48dhqAVXcgMos 9NMQ== X-Forwarded-Encrypted: i=1; AJvYcCVOKe2PehcoGx5ovhanjao6PFNHoxH8jcktWncMOaBN5gwLUL5FwbMQoxCf4d5fG/lJXWAbpa5c00KGv5P2@lists.postgresql.org X-Gm-Message-State: AOJu0YwZqKjhXuGW5P+0y4psQT5aVqE99lnv1Et0TviorsCLuOSHgiy+ I5OWi07CmL7MO+OO85Bl9oZ1iEDJI710aU92I5MzkYZpTxubkn8oHcuj+5UC1rVAfbmMPYLooz2 jYvxdPf4nX9+n07oesrE6H4YBP6U= X-Gm-Gg: ASbGncuV5l9pzN+STM099jo5aEdkawGsKYheuwbvKeGBbcLiL4P7Jx/jsKApsk/UgLI 0XMzQT03sX1yi8HEd3nlcw0T+L+rVBGtGynjUoB+lCQJaVe4z4855j+wvN5AqBBQBJIpDW6ccjY 69YupWVk0kc9row3rjJSi4zGoRlzlDNQ== X-Google-Smtp-Source: AGHT+IESW2ndArq5MpYsD+IW68yte4hi42h2iNCsbShPakUhSPtprqR8MnQZsjG8YJq4ib2SCtPxRdnQTYtdU5cjU0o= X-Received: by 2002:a2e:b892:0:b0:30b:efa3:b105 with SMTP id 38308e7fff4ca-3107f6ccc89mr1068521fa.19.1744781958459; Tue, 15 Apr 2025 22:39:18 -0700 (PDT) MIME-Version: 1.0 References: <1798838.1744759182@sss.pgh.pa.us> <20FB597F-641F-48F8-8428-D8DDBA802D58@yandex-team.ru> <1832513.1744777613@sss.pgh.pa.us> <0ED408AD-2209-4D60-9142-B6D01DD0C46F@yandex-team.ru> In-Reply-To: <0ED408AD-2209-4D60-9142-B6D01DD0C46F@yandex-team.ru> From: Kirill Reshke Date: Wed, 16 Apr 2025 10:39:07 +0500 X-Gm-Features: ATxdqUHtNe2pz4zRYJ-U4uxnqR5ziw7W-gbomzPoDG3l9N16mPnxYvtdm4Cd_4M Message-ID: Subject: Re: Built-in Raft replication To: Andrey Borodin Cc: Tom Lane , Konstantin Osipov , Greg Sabino Mullane , Nikolay Samokhvalov , 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 Wed, 16 Apr 2025 at 10:25, Andrey Borodin wrote: > > I think I can provide some reasons why it cannot be neither extension, no= r any part running within postmaster reign. > > 1. When joining cluster, there=E2=80=99s not PGDATA to run postmaster on = top of it. You can join the cluster on pg_basebackup of its master; So I dont get why this is an anti-extension restriction. > 2. After failover, old Primary node must rejoin cluster by running pg_rew= ind and following timeline switch. You can run bash from extension, what's the point? > The system in hand must be able to manipulate with PGDATA without startin= g Postgres. --=20 Best regards, Kirill Reshke