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 1t0vZf-00DqNp-I4 for pgsql-general@arkaria.postgresql.org; Wed, 16 Oct 2024 04:23:51 +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 1t0vZd-00FTns-OU for pgsql-general@arkaria.postgresql.org; Wed, 16 Oct 2024 04:23:50 +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.94.2) (envelope-from ) id 1t0vZd-00FTnj-D0 for pgsql-general@lists.postgresql.org; Wed, 16 Oct 2024 04:23:49 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t0vZb-001IH8-KG for pgsql-general@lists.postgresql.org; Wed, 16 Oct 2024 04:23:49 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-43115b31366so56014975e9.3 for ; Tue, 15 Oct 2024 21:23:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec.at; t=1729052626; x=1729657426; 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=PKCm1qzTDTqQ3YGBpEBf5RAM4kmRu8e186wwe2EuQjc=; b=HY+JXxhcnQf33vq7n1DETd4h2FcqALKtR7tmoIvqOd6zm2RzsaBf5J/g59r/xt9Jux 27I9kQHMg0DcX1ApduEVWiPMKAvjgIsup55q5otkq0JanURDW2z4yNPfL0I81Fft0ooR LWmCOxnYfHYTvPbb04Y22HPbbwtJqEYS/fq0M= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729052626; x=1729657426; 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=PKCm1qzTDTqQ3YGBpEBf5RAM4kmRu8e186wwe2EuQjc=; b=qMgySxph0zng/Fh0+SrLFJ4fikpWzAFyJ7sMncN3xddtbdspnqvLqercVS3p1hCIgg d//uYz24/YTQzgBrVn1XQ0w5cW9el/t0sdKLM9obwXAJGfWbXkeryLh7249F9TU5cT96 nltiM/j1+/suWrg1C4O1w3Ih0WFvhoxLTHsytsZsVOHjUkDrwphkEtsouOTt2rxk4/ka 8rlRMMqCZdNxQtGzEFBknjFpwI6AgVtNLNpzDkuIIdabVy2lEP7rCjOGydAorcf/qyIl KBND5cpNUMKx9q7GcS5VJ0EP7RGWr7gohRbi+NtNb8DOl+hMYAcLcucpCgMiNpcdra4c OvwA== X-Forwarded-Encrypted: i=1; AJvYcCV4dRrXBEQhQnPi81YmjeTgbQGnc7XJ5ED+PdHf1m3tSzlB/dXtO6e79e8nBUsrqUjJLn6jd7qnf1DaDhcK@lists.postgresql.org X-Gm-Message-State: AOJu0YwmO5161IieXBNLvYQpqLLufXGmncdf72MJftm3fx6oaqLeA7GJ utwI6xoEAHn7zF/pD66d867OU8uSYLyqyfoczqPXBGSCSOxS6dnKWsI6QUI0ZsdzAslh94T6cwj z6fU= X-Google-Smtp-Source: AGHT+IFLYrGksycaCglivYGPBUM06Z8BGrQxZU2g+n3RvIA8AqQEbNmbzC5oObrTWcPdry3Sro71pA== X-Received: by 2002:a5d:5259:0:b0:37c:cf0b:e9e6 with SMTP id ffacd0b85a97d-37d86d5521amr1781771f8f.42.1729052625815; Tue, 15 Oct 2024 21:23:45 -0700 (PDT) Received: from [10.20.0.55] (212-186-45-11.cable.dynamic.surfer.at. [212.186.45.11]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5c98d77995esm1272878a12.65.2024.10.15.21.23.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 15 Oct 2024 21:23:45 -0700 (PDT) Message-ID: Subject: Re: serializable master and non-serializable hot standby: feasible set up? From: Laurenz Albe To: Jacob Biesinger , pgsql-general@lists.postgresql.org Date: Wed, 16 Oct 2024 06:23:38 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2024-10-15 at 16:27 -0700, Jacob Biesinger wrote: > *would you* expect to be able to stand up a `repeatable read` replica aga= inst a > `serializable` master? My expectation is that you'd simply change the set= ting in > a .conf file on the replica and be good to go; is there something that wo= uld make > this process really difficult / impossible? I expect that to work fine, at least I cannot think of a problem with such = a setup. But I have been wrong before, so test it. Yours, Laurenz Albe