Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Installation - Mailing list pgsql-admin

From Nikhil Shetty
Subject Re: PostgreSQL Installation
Date
Msg-id CAFpL5VwiMLpPrt4755z7p3GTdWkxFk5O66KjTSMswDze963Wkw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Installation  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: PostgreSQL Installation  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
Hi Laurenz,

Just curious, Is there any technical advantage to having additional file systems for "pg_wal" and the log files.?

Thank you,
Nikhil

On Thu, Mar 10, 2022 at 3:14 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2022-03-10 at 10:04 +0200, edi mari wrote:
> What right way to split the PostgreSQL data between the file system (mount point) in Linux in the installation process?

Create your own file system for the data directory, so that PostgreSQL cannot fill the root file system.

It can make sense to provide additional file systems for "pg_wal" and the log files.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



pgsql-admin by date:

Previous
From: Graham Myers
Date:
Subject: Re: DB grow overtime with autovacuum (postgres 9.6.9)
Next
From: Laurenz Albe
Date:
Subject: Re: PostgreSQL Installation