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 1sEhYG-0033k5-J3 for pgsql-admin@arkaria.postgresql.org; Wed, 05 Jun 2024 03:43:06 +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 1sEhYG-004ZSJ-Ix for pgsql-admin@arkaria.postgresql.org; Wed, 05 Jun 2024 03:43:04 +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 1sEhYF-004ZSB-UZ for pgsql-admin@lists.postgresql.org; Wed, 05 Jun 2024 03:43:04 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sEhYD-0003XB-Iv for pgsql-admin@lists.postgresql.org; Wed, 05 Jun 2024 03:43:03 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id A812CEFB6D; Wed, 5 Jun 2024 03:42:59 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1717558979; bh=SiKyawEfXPGXLRWk4kOkJt+IpnQAj4ps47rE7xpyKiw=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=P8cSXm3Hs4qLxDDZX7N8UFAN+lDBmJD6tGpH4AvI/dh5OnZHpWWUPJIHEO5/w0dIA qOPtcqU5qXV7T0LzwYepHw1IrPCR1oH0pzcnIimPOhlcE15gUm/X1lrKyOCOCCECsl hLk05bfviWNl7i/ugVPqL3TfC9XoXGC7fMijjhltsKyC9NzzPTxPFJjRvgjtVLs56L 3is4jf8szAGWRh7/s/b2wqGQYZBzxioHbSLctwRFrI0ySpcEzc7LuKG5gsdBSk9uQl liRt7928k6A3fIJ8rSGOFSaTiSWmngYX5FID5/8DUFwUy9/Q05IVygKExfP+oYBqjR Y+dxl4bX7Smuw== X-Virus-Scanned: Debian amavisd-new at emo08-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo08-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5p7v0CaZwqBv; Wed, 5 Jun 2024 03:42:59 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 2C79EEFB6A; Wed, 5 Jun 2024 03:42:59 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1717558979; bh=SiKyawEfXPGXLRWk4kOkJt+IpnQAj4ps47rE7xpyKiw=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=P8cSXm3Hs4qLxDDZX7N8UFAN+lDBmJD6tGpH4AvI/dh5OnZHpWWUPJIHEO5/w0dIA qOPtcqU5qXV7T0LzwYepHw1IrPCR1oH0pzcnIimPOhlcE15gUm/X1lrKyOCOCCECsl hLk05bfviWNl7i/ugVPqL3TfC9XoXGC7fMijjhltsKyC9NzzPTxPFJjRvgjtVLs56L 3is4jf8szAGWRh7/s/b2wqGQYZBzxioHbSLctwRFrI0ySpcEzc7LuKG5gsdBSk9uQl liRt7928k6A3fIJ8rSGOFSaTiSWmngYX5FID5/8DUFwUy9/Q05IVygKExfP+oYBqjR Y+dxl4bX7Smuw== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\)) Subject: Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` From: Scott Ribe In-Reply-To: Date: Tue, 4 Jun 2024 21:42:48 -0600 Cc: "pgsql-admin@lists.postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <0475684C-37A1-403D-8147-26D7FE860845@elevated-dev.com> References: To: mohan.nbs.ont@gmail.com X-Mailer: Apple Mail (2.3774.600.62) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 4, 2024, at 9:36=E2=80=AFPM, Kashif Zeeshan = wrote: >=20 > we are not using slots due to storage related issues that could occur = if the network is broken If you can ever upgrade to a current version, then there's a parameter = that can be set to put a limit on retained WAL, so that in case of = network failure, it sacrifices the ability to bring the replica back = online quickly in favor of not bringing the primary down with disk full = condition.=