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 1uvqnw-002bQW-Hm for pgsql-general@arkaria.postgresql.org; Tue, 09 Sep 2025 05:22:09 +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 1uvqnv-009e8q-0U for pgsql-general@arkaria.postgresql.org; Tue, 09 Sep 2025 05:22:07 +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 1uvqnu-009e8W-Kf for pgsql-general@lists.postgresql.org; Tue, 09 Sep 2025 05:22:07 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uvqnt-001HVI-18 for pgsql-general@lists.postgresql.org; Tue, 09 Sep 2025 05:22:06 +0000 Received: by mail-wr1-x42c.google.com with SMTP id ffacd0b85a97d-3e4aeaa57b9so2542148f8f.1 for ; Mon, 08 Sep 2025 22:22:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1757395324; x=1758000124; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=6XLiEdnffQ6ueKrRIw1D7Z5gL9ns8cewlw2KLSzq1U0=; b=I6lE0Wf+Lcfaw2hfH4HUBi4YXQsO8Mapul9xPAi0EmZmP3jTGXsSWWEDgZ1K2vC4S1 yRTqSG9FA75kzvFiW+//8hEgtBTPT5fkHPCiR3t6Yli23jQWG95uPXIZfvM1s3Y+3yOy 4aEvUmziekOJJCf9OPQ9JWQrlgY0EsN0koW6rXzkkTaARnU6EZeQqw+uBf6LIm3OptK2 rCpPnjFMFv2CK5QAdG6E9qcTZrzHwlmsFLobZyT1kBFXHL3ZLZx0dKNRHKz5Wv2uhHG8 eMB2sLdnpDk6nRYBuMLSMFVmJnmFJtQW47hAQ8zPMQKcNAvWv77+X++pjunDet7euVZX HtFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757395324; x=1758000124; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=6XLiEdnffQ6ueKrRIw1D7Z5gL9ns8cewlw2KLSzq1U0=; b=JSfVScMle/rJ4Oa2AFk37slgUfhqx8Ld87PqJVm0MOc6v32HwGvKm8lhQ84DUiuBpx yl+gs9HBl/gFORjh0f3D9QeedSTKfu/rZlhNQg7GCN2Od4qqhl8roDMXkz349symDdI6 CLxNtCnqliEb3eE4tZonV46eTARGyyzQrrToK7KDzEPI08ttjjA7bV0EfoFgBdlzNd/O o9isJBU4mX8/12svWpv8OcPW6mQZ9CPOZ/YGapxRQUpEsTytLRxOpOwpZyxXtTbnaqTd RbA554wwZKuheFkmkb2Zgo/L9Xmur+L1QIvfBBkaP+yPsG1o1wqpgKB1GQifwQ84MucS LwbA== X-Forwarded-Encrypted: i=1; AJvYcCW/UAZnc7Se66v2TekadcYpnu9aV43+yc4LC2sW1Whs8/y9xJ8rvdzzahUrcsxe1hnGX10D9EjIlDxdamdY@lists.postgresql.org X-Gm-Message-State: AOJu0YyXCvAFo76IoqL2Nj63rbJ4svJe0QDKblFVGliTxctpf7603fXs uzpdxuOCH9BWQuMXKWvAA/RqwVL0jVKIJDbfbKPG/0wiEHfDXr0VDWB8bKTXWTjqp2s= X-Gm-Gg: ASbGnctMMRbfB6F/qSP4nkkelFcC9H0uZ6gAUdVLMNM9dMcJhWJvu1jk0VnprYr6ncj EGwU87M6u3nzjM2mliboE7f47EOFt+VxrhHSxugpgl186nmZ3WPxgqeSTaF2bevv3PNEdGsPl60 MPSywzETfDQALGoSyg4YrNCoeMhFzgsdtMIWb4uxBEf0EagGVek9lSykKNqEe7fOZIIlw4i8JGY I1OJDQPVwsnQY9jt/+CjcB0faoP5GvnSbRFN+mwOPnYf7fWBEvfM7MEqWoiOvY9DYGMwzKlpGxk pQJUJU9H28HUOJ0u+ABD1wHNd1RiR8023B7M74MrQ+m3xfbEJ/irc9G5QN1zs/NwkloSopeBj5e rZ3R3xr/mECuijRMXJDBcqEYT5/ImQtja3KEezckj6XuiaLzlv5SCxJmLi+IFjjk= X-Google-Smtp-Source: AGHT+IH4YgcuWT8bsZj1yul+qUGKDe/rp4Nh/KVTa66mRTy6WA8NUlVeigBbehNfTDOMYR1L8n8n3Q== X-Received: by 2002:a05:6000:1acd:b0:3d1:e1b1:9640 with SMTP id ffacd0b85a97d-3e643ff6d7emr8474401f8f.30.1757395323792; Mon, 08 Sep 2025 22:22:03 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:255:30a:2403:9037:2d08:c2c]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3e7521bf85esm1038116f8f.1.2025.09.08.22.22.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 08 Sep 2025 22:22:03 -0700 (PDT) Message-ID: <2d3e2950574f10941e942d3053356b41b6e136b6.camel@cybertec.at> Subject: Re: =?ISO-8859-1?Q?Re=A0=3A?= Fast switchover From: Laurenz Albe To: legrand legrand , "pgsql-general@lists.postgresql.org" Date: Tue, 09 Sep 2025 07:22:02 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2025-09-09 at 05:07 +0000, legrand legrand wrote: > > > what could we expect (in term of downtime in both worlds) ? >=20 > > Usually seconds, so plan for ten minutes. >=20 > Brrr, I was th=C3=AEnking about a more reliable process. If you want more reliable numbers, make a test run on your system. Yours, Laurenz Albe