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 1sjjiv-003Stn-Fu for pgsql-admin@arkaria.postgresql.org; Thu, 29 Aug 2024 18:18:21 +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 1sjjit-005h9E-L9 for pgsql-admin@arkaria.postgresql.org; Thu, 29 Aug 2024 18:18:20 +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 1sjjit-005h8J-AE for pgsql-admin@lists.postgresql.org; Thu, 29 Aug 2024 18:18:19 +0000 Received: from mx0b-0039f802.pphosted.com ([205.220.176.45]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjjip-0027WJ-59 for pgsql-admin@lists.postgresql.org; Thu, 29 Aug 2024 18:18:18 +0000 Received: from pps.filterd (m0209982.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 47TH4QVU023694 for ; Thu, 29 Aug 2024 11:18:13 -0700 Received: from mail-oo1-f71.google.com (mail-oo1-f71.google.com [209.85.161.71]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 419pukjhyc-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Thu, 29 Aug 2024 11:18:13 -0700 (PDT) Received: by mail-oo1-f71.google.com with SMTP id 006d021491bc7-5dfa81c231dso389352eaf.1 for ; Thu, 29 Aug 2024 11:18:13 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724955493; x=1725560293; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=xDqGO81naP0NXjosgBhFgVgVwd6cxdqCUz1JL4X4AzU=; b=vZQNwQvHe0gR9ESPXlTOaZ0+RSdWbeelaVitx0PwM0nVUQ35O7VJVd6n4WQ2mdPQIX J7F23nNxiYDlcXffMAnnxSgnOH3rq36yxi6zE9N3obKt77guHzH5qz9JyQg3apdVJy4t DoTwhkCwJlWYTsRXXXFGM2qV8H5gWZsi8DoTAUaU7GwPCo0eJfX4a7B4GmcGxFaw721Y m+CuZH373fudM0yUEkqPUzj6MAbsGQjlwyvw5mOBesisf1DPLAvBXYzx9MJtI1I5mY+K HNx4BmX+0w9d0ITSUck4E9Z+xakeHdN/0hVIeZQPEK4S0d/8RNpwDmwvqbo8TUxCHZQ8 DXMQ== X-Gm-Message-State: AOJu0YxWodZcJ48PUTQvCHdTRoanpy1aNaN137DxJTBZzonlRnajKt58 LwBOhyUlhGfXj1sTt8ZJQkNRNBGDbwP796kGyFitgy+MBYsup4/i0yk0DIZxC81mOoqyFoE9JrI FLy4D6D7j/hLVKoVpAK33hDOMqPSdug5VYHpW9ku85IAONVdC8IL9PsYn2w+Rc9KYaC++AHPU9U Q993hSyDIoeb1wyiNhkmE53C1AysTY5bMhzwURZcikz5sG7k7wHE4Ly4vqyAIA1uejXWGDFWW7k wM= X-Received: by 2002:a05:6870:7191:b0:261:164e:d12a with SMTP id 586e51a60fabf-2779013ab01mr3857926fac.22.1724955492930; Thu, 29 Aug 2024 11:18:12 -0700 (PDT) X-Google-Smtp-Source: AGHT+IE30cGdrAuWUWo0FQXEfk/vfFqptN3PVP/ppfsKyZONyzsgDsMd7YVewDv1IKMu6hi8zik/psJ4/3/4s7J4TIo= X-Received: by 2002:a05:6870:7191:b0:261:164e:d12a with SMTP id 586e51a60fabf-2779013ab01mr3857908fac.22.1724955492576; Thu, 29 Aug 2024 11:18:12 -0700 (PDT) MIME-Version: 1.0 From: Henry Ashu Date: Thu, 29 Aug 2024 11:18:02 -0700 Message-ID: Subject: Postgresql Database and PG_WAL locations To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000638b850620d67f82" X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16 definitions=2024-08-29_06,2024-08-29_02,2024-05-17_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000638b850620d67f82 Content-Type: text/plain; charset="UTF-8" I have a database that's about 2TB in size, and I want to place the database files in a separate mount point(PGDATA) and the log files in a different mount point(PG_WAL). What's your take on this?. Thank you *Henry Ashu* Database Administrator *o:* 503.672.5114 | *f:* 800.551.8821 | DAT.com [image: DAT Solutions] [image: Like us on Facebook] [image: Follow us on Twitter] [image: Connect with us on LinkedIn] [image: Visit our YouTube Channel] [image: Visit us on Instagram] --000000000000638b850620d67f82 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have a database that's about 2TB in size, and I want= to place the database files in a separate=C2=A0mount point(PGDATA) and the= log files in a different mount point(PG_WAL). What's your take=C2=A0on= this?.

Thank you

Henry Ashu

Database Admin= istrator
o:=C2=A0503.672.5114=C2=A0|=C2=A0f:=C2=A0800.551.8821=C2= =A0|=C2=A0DAT.com

<= div style=3D"color:rgb(0,0,0);font-family:"Times New Roman";font-= size:medium">3D"DAT=C2=A0 =C2=A0= =C2=A0=C2=A0=C2=A0= 3D"Follow=C2=A0=C2=A03D"Connect=C2=A0=C2=A03D"Visit=C2=A0=C2=A0=3D"Visit
--000000000000638b850620d67f82--