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 1rfM5y-00H951-Kl for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 15:43:47 +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 1rfM5w-00BiSA-9f for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 15:43:44 +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 1rfM5v-00BiS1-U3 for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 15:43:44 +0000 Received: from sonic301-2.consmr.mail.bf2.yahoo.com ([74.6.129.41]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfM5s-001pwl-GJ for pgsql-general@postgresql.org; Wed, 28 Feb 2024 15:43:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709135017; bh=sqQIC1LQrPOdWNTFmVF8k3hRevrViY68Fboaz5rpOkY=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=kkD3MKzPvHn417Xos3oJxQXv/JB53xH7F2XpAbyJhRdMmA6cWO3I/plflkBI2cpuyJugf3wW/kNQ1p63sgJerkemgqi28czYcs0jJ7tQhsoSyaIarWpcD0tDgINptwpoyCGONNB6XmT37up51uoFBZ4PWQlyuefbwKRIUbQx5UqIZzdHl+gSfFLwJqMjGTTqIjE8R26BfaNdOiDYBnesifcNWAXSNuKb9kFLk6He/SHAKDgnRTREOChrsJTd/42vxk2lg0pFDPX+1PuPCx42PnwR8jK854XCfjW60br8t9osnvbK5JFMibNEZUSc9Y2LiV8mLXm4GcMxftcwpcsoTw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709135017; bh=7lyUGUI4JSRXdu1Wcdn2Kb8YtnQ80jLwwMdfG0m4HqJ=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=I4AU7UelIfRpXLN9S2/Dc4XfgqyBTEfxg0XttIQhPzEiHNOJH4FC+2FTte9G8s6UaLNB/WE64M+iRgrt4mAuQDg5ZXyrG34doWDSKzyJpsKJybIOl5Ply6rPDG/BoJmhTueO/HYcJES2GI3hOmYhyWKfmA+7om3eEV3uQUZAubo2XnJXUHw4rJ+0XCOhBUn1JmdXQg/8Ea7hX3TW41n3H7BtOz9bBJoyiny8JVSlXRX6E9U8Z6/EGmQpUofyYu+f1TUmKBaI0Hv5Xd0o9GKvT4wGupSe+R9uuE1Jad++0meAUTa9622FMaNBbt+K+tD3hqeT/NSB72RPZ/naLATpBg== X-YMail-OSG: U2WxTl8VM1kL7I80xuZ85ohrl9EWQ6sUiIlE_7Sbcjp2eSvi1Kkz7GpTd.lYm5E YUSBGbFkESPluG_rVmFZBusRxcQ1Nar1zUSZ23NGQzNVhqkCb0XkSMooeYOAhNyXh7473h2exiEl BDKOGbuRwVtSipuvve0mcpp7qInzJtZUpWYVFi5fiVtzQZOzrjw8IpNzQh8Jc.g1YGkxmu0ns.ex Y90up8nipQhKH9aJLO9AcOLAAXWNiF0uqnKuWW88AdV.fwA9QjO17xIjwFUKv4tLKYn8vPU0Fmx6 GF0UP8xBX345Ue29_MTms.ALBy7E4pxP9Uo2K5P3g_Tw3lGqPP9tPyJ_QZ5ixb9FHXc8cIQ_J0E2 wLCU5tT3UvcXtM6PW9eWHa9TkS86ylGRTilD_rEibqmYKAnS2dpwvRWvf1BH.tDArz7.xTpciYKr EMoS7rxBgDguA3CLgTpmo0i4Iay5XhsbAca0EE982J.clwm16LMIapR.uwV8mHTliMpUXk._LNIK t7Jk82AUaRwsrLEBkR9oEPLaMUuKy6OKGRnxZF9beewX9WJ3laibjv1W8ffAIlqEgi3HuHJVBsYK Xcb3Sofkj.ALmqDkjLw0xSiGynT9Gh0b428.mpBa7.IDvEdmseRCauT7877vLzXyYY3c4uOcZ_EY 2lM2_JbERtVwYpPPD0sdeD2VyefmnxjklsdYZP1Y7O1ZskuYlMa8QYFsVh_3j2j.LQWMThfILuQH 1Xt5pq1xrunVjpqczBM5OdL4TRc5hmWuFXR0SOc8WR5cNzZTEK2GJ5rdhBE_92rkT0.wSf.1ohSE Ngaxx84oa0Cpw0n5RtNjHPF0oZT8trxsofVaP5CJa1N4MsuccNVVlAqFJfQPrBcsVncTC.PM50lO 6njXmBXDWlKJ7sNcGbt_qGm31hAZYEFHaFRGyG3Nk7lftsheQ83GS_jDs2tpDBjzCmAxhW4.wDRQ lVKK8jpHYoLP4cmLVA_1PgN0ANCwra.fjbyCQ1DP7xsVs80CQgrRuYt3JITGEdoWq.WJl_9bbv3g KnDkRAMOTLCe1pWkTR5F2E_I85Hnmiea_LJbWqZNekCf2wU6ee.I7EHINH1kRQMAYwYMmXzhB960 N8XxjSHggTRT7iAeE.1JU76hjd0mTYm_jKgw_Rj6AUFwOrkv_ifVVW4yn323BN9VKVW2bIUv1PwG Dc0JTFVBl.c.5nNOWEqvQ.4bU4ZldUcTDIrkhQXfnkh5lgqUtHy0qniZqR6BIqTzqIlT5p56ErPI UtAlSz_cOJqwqFFuAKpX5CZkY6Xt_eEpLBKY.hCQvyjda7knvktSEnCXK7eDyZuWT1.u9KlAeeLb Nn0oRQAa3nGc2xtLA6daYhYOeq3JGEv.r8TmoeMJmXXo0ybulUt8UPu3rt7JiS6x5BdC19RuaFgl LZ6vNE1HUlmMHrGphJh_4KAyxFWD739FtpAgXDOCzItdtxM775_Qa4sdepS0rf74ORkAWI1154yk kePdbZ4PwfmBSnA3XnahQFbFJvYaHZ4cFH8bySmC.g.4XT24vGjb5XB7RjJuCiLr5Jz54WIFdEd3 Y3em2nCwzZKyyiUGO6doUoC2Mw6P2t7ZpKYDbsjYWPMtRNyDuniDp9O1tqrBL7Pe96Z9aJ4zecv7 WX3J5MyLqaPuyP28_NOdqcV641wPDIbsQUNslL7pU1hUGNqnXO3FvCA2neK9iXfAn2Q_BHM6aajU ro5A211fiuDGsL0DymU8gb9Y_ETmiPZc31OLdjVJtquSlQST9uyeQINojYlzIxNYt73irM5Pe.8g nsnuk0yTsNo19NScFAsquASMo5SX5_78iC518DHyV5i76U7SjNEYmaTEJzXkezGs0H.W3F2g4em6 6RBLNL.pRePsiUcPjj6BDeGlD_5ncV4TAdgmgZ9UjGFB5nViQIQNr_jfUbFylRrhRPHjbIWebfPC O1MnUcjzNttxvLra5swDJy5KM6BV6vGxyBGfkORhTBg2oSVzph5FZdGe9iqgdQLjzg1kvye2lZqH SZXltzxRdqo.Sofis6ccct8WLcFHpXQsNuhjvHcR6vSSGDd5uYjtfT7cXxcX3rdgSTZpEfr3c.SI 6GM2rpGYDrNt6B.YGmZ4rRc2oUv7qbkgfUsjnVMByaQYXc9lVPla6.UwSwZSs5PrOBkgSsTk.o2D IBgD9D9DAPGRGTv5SIpQFvHyH8XcyV.GycBlbEFqpv1UE_7zeznrDYu7i7vsncC8y3jZXDmYwlca KdMRUnExOtZSgEryILj1dyP_W0yYOyg_XE23pUnWLp75fq3_8ZSLMbg0r8NG9rDCjSsOuiJHk9Rl E0mskKGNuoCpgNMzacp2.vWlQcPzv_rQY1wFJ0TjNP52aF0lLsf1TMKyxoAiCzm0DcGjO05PG2Tk 5.tYiU3.zzcfbO8ziZFhTpGB7H._Ld2BkbXKMg6YeUtUTNNsrMw-- X-Sonic-MF: X-Sonic-ID: bc2810d0-0ed6-4752-aa9c-58991dfbe945 Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Wed, 28 Feb 2024 15:43:37 +0000 Date: Wed, 28 Feb 2024 15:43:32 +0000 (UTC) From: Jason Long Reply-To: Jason Long To: folarte@peoplecall.com Cc: "pgsql-general@postgresql.org" Message-ID: <846580225.1063051.1709135012618@mail.yahoo.com> In-Reply-To: References: <1413835786.1017118.1709123670125.ref@mail.yahoo.com> <1413835786.1017118.1709123670125@mail.yahoo.com> Subject: Re: PostgreSQL Read-only mode usage MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1063050_1572519327.1709135012617" X-Mailer: WebService/1.1.22103 YahooMailAndroidMobile Content-Length: 2972 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1063050_1572519327.1709135012617 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,1- What does it mean, not the whole database? 2- Can this be considered a kind of guard? 3-=C2=A0Can you tell me a read-only scenario? For example, if we have three= servers, then one of the servers can be the main server and the other two = servers can be read only.=20 =20 On Wed, Feb 28, 2024 at 4:24 PM, Francisco Olarte= wrote: On Wed, 28 Feb 2024 at 13:34, Jason Long wr= ote: > What is the use of a database in read-only mode? Normally it is a connection/session to the database what is in read-only mode, not the whole database. As it has been pointed out, you connect in read only mode to read, so you are protected from accidental modifications. Also, knowing your transactions are not going to write make life easier for optimizers and other things. Francisco Olarte. =20 ------=_Part_1063050_1572519327.1709135012617 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
1- What does it mean, not the whole database?

2- Can = this be considered a kind of guard?

3- Can you tell me= a read-only scenario? For example, if we have three servers, then one of t= he servers can be the main server and the other two servers can be read onl= y.

On Wed, Feb 28, 2024 at 4= :24 PM, Francisco Olarte
<folarte@peoplecall.com> wrote:
On Wed, 28 Feb 2024 at 13:34, Jason Long <hack3rcon@yahoo.com> wrote:

> What is the use of a database= in read-only mode?


Normally it = is a connection/session to the database what is in
read-o= nly mode, not the whole database.

As i= t has been pointed out, you connect in read only mode to read, so
you are protected from accidental modifications. Also, knowing yo= ur
transactions are not going to write make life easier f= or optimizers
and other things.

Francisco Olarte.

------=_Part_1063050_1572519327.1709135012617--