| 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 |