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 1txmmw-00EekV-NC for pgsql-docs@arkaria.postgresql.org; Thu, 27 Mar 2025 12:56: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 1txmmv-005ybN-En for pgsql-docs@arkaria.postgresql.org; Thu, 27 Mar 2025 12:56:49 +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 1txmmu-005ybD-MQ for pgsql-docs@lists.postgresql.org; Thu, 27 Mar 2025 12:56:49 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1txmmq-001W3F-3D for pgsql-docs@lists.postgresql.org; Thu, 27 Mar 2025 12:56:48 +0000 Received: from phl-compute-13.internal (phl-compute-13.phl.internal [10.202.2.53]) by mailfout.phl.internal (Postfix) with ESMTP id D454D13833BB; Thu, 27 Mar 2025 08:56:42 -0400 (EDT) Received: from phl-imap-09 ([10.202.2.99]) by phl-compute-13.internal (MEProxy); Thu, 27 Mar 2025 08:56:42 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1743080202; x=1743166602; bh=9/wvApvIz2 qfMhndTQh3NVGkkqWBAuZyQVzOiOCdAx8=; b=GKU3rok79+PVjGOjHnH13y5vGd z86xWRmZHQ/5dpxZPFuifip6+9VOUUg13G3u5EA+Jwxtg8UjiD1MJ0+FqvGixe3p SEEUsWcOxqGMjT+0ZGrufmOsa5wGEjT7F5yNENa0s85zBtt5KPTkKl1Zv3g4c8Ns SlGOw7kpHx1s8qjg9HuLO84Ic7wzTuxCfjXT1ZmWO1EbNYGjRwzLPxQVUk8Yoxux G8FS/tl2O8OTCn2oRVXBy0+26sQy617+Q3ilC4Vt3BjbufHj6H3muC/Li9jYxy5u Cut8ip06BEIUEHmWqON3QsWLV+FPDGAHIad7puQsLkFJpRRElosQxhEeg/lw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1743080202; x=1743166602; bh=9/wvApvIz2qfMhndTQh3NVGkkqWBAuZyQVz OiOCdAx8=; b=UJuoBO2yUfE1Rlrbs51me99htQdzeBHhjIjZk+3IKVdJrsg3Szf fsorvk2MjcAJ5VRrIYy0jJMjNJtpjt2yRruCukciJdsXyVTF/1PFDNKvpjqi05Zt 4MVTMAYqfYO8LcSH2PDGG8LyVRwpMRlY7ngR+1mitdZAqhFmcZNr+BsTJtlPh1vF 0qHZj2+VJgNl2pwWK6ZtS4/bte8PXLSyLBMEWbTbCidC5diVF0xG5SKz9tlnC3KX iqJiqtLiMb/diHsK1p5PO1eCSS/aOQHN4LkrNqyzdVEpnNU7TmAypK1aoiYRGz4L P2XZ1q2DbhyiCIbj8QkvgI9oKQSbw8Ydjvw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduieekgeejucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepofggfffhvffkjghfufgtsegrtderreertddt necuhfhrohhmpedfgfhulhgvrhcuvfgrvhgvihhrrgdfuceovghulhgvrhesvghulhgvrh htohdrtghomheqnecuggftrfgrthhtvghrnhephfdtudelueefleetuddtudekkeefueeg vdfgjeetgefgffetieffudfggfeuffetnecuffhomhgrihhnpegvnhhtvghrphhrihhsvg gusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhr ohhmpegvuhhlvghrsegvuhhlvghrthhordgtohhmpdhnsggprhgtphhtthhopeegpdhmoh guvgepshhmthhpohhuthdprhgtphhtthhopehlrghurhgvnhiirdgrlhgsvgestgihsggv rhhtvggtrdgrthdprhgtphhtthhopegurghvihgurdhgrdhjohhhnhhsthhonhesghhmrg hilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdguohgtsheslhhishhtshdrphhoshht ghhrvghsqhhlrdhorhhgpdhrtghpthhtohepthdrhhgvrhhlohesphhrohhvvghnthgrrd guvg X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 9C9DC780068; Thu, 27 Mar 2025 08:56:42 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: T4f03952b6de3be27 Date: Thu, 27 Mar 2025 09:56:22 -0300 From: "Euler Taveira" To: "Theodor Herlo" , "Laurenz Albe" , "David G. Johnston" , "pgsql-docs@lists.postgresql.org" Message-Id: In-Reply-To: References: <174291831170.676.262776479364497352@wrigleys.postgresql.org> <1f38ffb000b9ead35702a63191c28f36e259c7d1.camel@cybertec.at> Subject: Re: Documentation for initdb option --waldir Content-Type: multipart/alternative; boundary=94c12f8bf25847c49dda4c9c146a30c7 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --94c12f8bf25847c49dda4c9c146a30c7 Content-Type: text/plain Content-Transfer-Encoding: 7bit On Thu, Mar 27, 2025, at 8:40 AM, Theodor Herlo wrote: > Both look great to me! I thought the advantage of having different devices is also to easy I/O load. But I guess you have to decide for yourself what is the best strategy. For me it was important to know what initdb does with ---waldir. And this is nicely explained here. > One more little thing, I stumbled across " should not be a mount point", sounds thirst like it was not good to use the mount point. Maybe: " should not be the mount point itself but a directory in the mount point". It might be only me, you diced. Laurenz suggestion looks good to me with some suggestions. I agree with Theodor's addition but I would use the same sentence from the source code that says 'subdirectory under the mount point'. I would also consider and/or modify pg_basebackup documentation that has a similar option. My suggestion is that waldir option in both tools has similar sentences. The term 'WAL location' is not appropriate because this terminology is already used to indicate the LSN. I would replace it with WAL directory. -- Euler Taveira EDB https://www.enterprisedb.com/ --94c12f8bf25847c49dda4c9c146a30c7 Content-Type: text/html Content-Transfer-Encoding: quoted-printable