From: | Matthew Tice <mjtice(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Postgresql Database and PG_WAL locations |
Date: | 2024-08-29 18:21:38 |
Message-ID: | 5BDE97CE-242C-479A-BDC7-CF263BBD554B@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> On Aug 29, 2024, at 12:18 PM, Henry Ashu <henry(dot)ashu(at)dat(dot)com> wrote:
>
> 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?.
Take a look at https://wiki.postgresql.org/wiki/Installation_and_Administration_Best_practices
Essentially, yes, you will want your WAL and data stored on different devices (or the very least, different partitions).
> Thank you
>
> Henry Ashu
>
> Database Administrator
> o: 503.672.5114 | f: 800.551.8821 | DAT.com
>
> <https://www.dat.com/> <https://www.facebook.com/loadboards> <https://twitter.com/loadboards> <https://www.linkedin.com/company/datsolutions> <https://www.youtube.com/datloadboards> <https://instagram.com/dat_solutions>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-08-29 18:58:53 | Re: Postgresql Software Location |
Previous Message | Henry Ashu | 2024-08-29 18:18:02 | Postgresql Database and PG_WAL locations |