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 1s4IrT-002c7B-Vo for pgsql-novice@arkaria.postgresql.org; Tue, 07 May 2024 11:19:55 +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 1s4IrR-002M0e-FO for pgsql-novice@arkaria.postgresql.org; Tue, 07 May 2024 11:19:54 +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 1s4IpI-002Kdm-GY for pgsql-novice@lists.postgresql.org; Tue, 07 May 2024 11:17:41 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s4IpG-001zgE-DG for pgsql-novice@lists.postgresql.org; Tue, 07 May 2024 11:17:40 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-a59ad344f7dso575089866b.0 for ; Tue, 07 May 2024 04:17:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1715080657; x=1715685457; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to; bh=rGrx46P4EgzuAq8Ea7XsgmMNKkzXnL8hXzQRAiFU9P8=; b=rNNfY9ASqIAmwWYxbAbYcM8dLt8FKP9l1+IzioyFWYEl2f4ySCWU1QejPCHy3wxmOU 3Kw5t9aBazGZQZnR2Qx7S5S7wXdcmOH1ZmiZPWPHPMY+4u/bXEYUGzE6rY9ariW12jSI X+7p7C6p7m4qUnY3v7HWlJt4QS75S3NbgybdpILMHzksCEuecV3YgBJEgNJDtAPCpnyi ZjOXP6mhn0Iwvclg+m1zrjOtwHwCP6U2p2ssnphGBpimrnnRH4+NWKggVnfpw5V01/w8 np2F0gO0DPi59Jbdtbq6rRgcQ1Hw0A4r4Rap9X7PlffW8ikrOIKbGSC3R4gVpgwCzOXs zkwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715080657; x=1715685457; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=rGrx46P4EgzuAq8Ea7XsgmMNKkzXnL8hXzQRAiFU9P8=; b=EEZKn5rvX7HwF17LdRBt7uq6wAvswnKtLWTMkI7Kx3gZp9yMFe7EJmI3Bi+LEzZ8xB IxjDjAJQDaUbbsCT/AKNLz1GdB/1QcdBDLdo73BcRyBv4JMpFffZIwoaLzrmUugu1aNm zWqXiKOi86HHxB1phyoxxqju3UBn3E6zIcWMvTM2iDTDuJqiwBpYHqIw9ZCXUnWbWPed tEsaeUeZEmasEROAjnWxpRotnq6pwF8wI/c7YrQDcUFakX0CYmk7MHdsMgJbPafBoedu 6EWw8y7vdlD+yr0nnbTh/dJS78z8wVyUyhjc0DEM8+hkMSdWtPccd3rxxNXkDpPtv2Za nE6w== X-Gm-Message-State: AOJu0YyPjE7/rR53Oe+vCenu5+9PxIYoUtNucfE1iATis33nrM8JXEPV 2XiEmgFqqv6qJ/UYHCBi5Fm3SxqZ67R78cPEShk3jD/vG/+ugu1uttR+X6BMc96bfRCCFsegpus GQ/Y= X-Google-Smtp-Source: AGHT+IFiPt52v3HsxQ3M74+AlkuA6DEfoUI3YV1WjtQdlZLAp8RnJfgdeDAi/8JbhqoMITOYL8wVeQ== X-Received: by 2002:a17:907:ca01:b0:a59:8cd2:5b2c with SMTP id uk1-20020a170907ca0100b00a598cd25b2cmr6460185ejc.39.1715080656880; Tue, 07 May 2024 04:17:36 -0700 (PDT) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id z4-20020a17090655c400b00a5931d77634sm6350223ejp.34.2024.05.07.04.17.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 07 May 2024 04:17:36 -0700 (PDT) Message-ID: <5c3bd0e10a40b16218df384dd402835df3ac17c6.camel@cybertec.at> Subject: Re: Access a Postgres storage with two independent instances From: Laurenz Albe To: first last , Alan Hodgson Cc: pgsql-novice@lists.postgresql.org, pgsql-sql@lists.postgresql.org Date: Tue, 07 May 2024 13:17:35 +0200 In-Reply-To: References: <03caa4a3b0daf352e53e99212baa9c012cd744f2.camel@lists.simkin.ca> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2024-05-07 at 09:56 +0530, first last wrote: > But, when I deploy MySQL/MongoDB deployment with multiple replicas to > access the same storage, the all pods except one become=C2=A0CrashLoopBac= kOff > state. This is happening for MySQL/Mongo. When it comes to Postgres, I > deployed it with multiple pods, all the pods became healthy and there is > no such=C2=A0CrashLoopBackOff state occurred. But those pods access diffe= rent > storages for every pod. Why this totally different from MySQL and Mongo? Because it is different software? "Why" questions are notoriously hard to answer (as anyone knows who has ever had children). Shared-storage architectures are not great, because they have a single point of failure and only scale very moderately. So there are no efforts in PostgreSQL to make that work. Yours, Laurenz Albe