Message-ID: <7002449259b582723ed7e041a7f0de116b48ad4d.camel@cybertec.at>
Subject: Re: Creating a new database on a different file system
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Luca Ferrari <fluca1978@gmail.com>, Ian Dauncey
 <Ian.Dauncey@bankzero.co.za>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: Mon, 17 Mar 2025 16:18:13 +0100
In-Reply-To: <CAKoxK+4RTRP+phsnJgMjVzFVjmAHdu2wCXG_5YtsFR_fJEY6_Q@mail.gmail.com>
References: 
	<AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com>
	 <CAKoxK+4RTRP+phsnJgMjVzFVjmAHdu2wCXG_5YtsFR_fJEY6_Q@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/7002449259b582723ed7e041a7f0de116b48ad4d.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-03-17 at 15:51 +0100, Luca Ferrari wrote:
> On Mon, Mar 17, 2025 at 3:49=E2=80=AFPM Ian Dauncey <Ian.Dauncey@bankzero=
.co.za> wrote:
> > We have created a few databases on the file system defined in the postg=
resql.conf,
> > but now I would like to create another database within the same cluster=
 but on a
> > different file system.
> >=20
> > Is this possible and if so, how do we go about it.
>=20
> create a tablespace on the filesystem you want to use, and then create
> the database adding the `WITH TABLESPACE` clause.
> See <https://www.postgresql.org/docs/17/sql-createtablespace.html>

That is an option, but I would recommend to create a new database cluster
on the new file system rather than creating a tablespace.

Yours,
Laurenz Albe