Message-ID: <66585a0d3b617bc2cba8ebbe3f0a479bee9c6324.camel@cybertec.at>
Subject: Re: Creating a new database on a different file system
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>, "pgsql-general@postgresql.org"
	 <pgsql-general@postgresql.org>
Date: Mon, 17 Mar 2025 21:30:46 +0100
In-Reply-To: <CANzqJaCZH2KmjOpAWXA=jUb-+He0D68sgY-YTibjk4bmH5Qt0A@mail.gmail.com>
References: 
	<AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com>
	 <CAKoxK+4RTRP+phsnJgMjVzFVjmAHdu2wCXG_5YtsFR_fJEY6_Q@mail.gmail.com>
	 <7002449259b582723ed7e041a7f0de116b48ad4d.camel@cybertec.at>
	 <CANzqJaCZH2KmjOpAWXA=jUb-+He0D68sgY-YTibjk4bmH5Qt0A@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/66585a0d3b617bc2cba8ebbe3f0a479bee9c6324.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-03-17 at 14:33 -0400, Ron Johnson wrote:
> On Mon, Mar 17, 2025 at 11:18=E2=80=AFAM Laurenz Albe <laurenz.albe@cyber=
tec.at> wrote:
> > 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@bank=
zero.co.za> wrote:
> > > > We have created a few databases on the file system defined in the p=
ostgresql.conf,
> > > > but now I would like to create another database within the same clu=
ster 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 creat=
e
> > > the database adding the `WITH TABLESPACE` clause.
> > > See <https://www.postgresql.org/docs/17/sql-createtablespace.html>
> >=20
> > That is an option, but I would recommend to create a new database clust=
er
> > on the new file system rather than creating a tablespace.
>=20
> That of course requires using another port, which can be tricky in a comp=
any that by
> default closes all firewall ports at the network switch level, and where =
you must
> enumerate every server/subnet ("Rejected. Subnet range too broad!") that =
needs access
> to the new port, it takes time for requests for new port openings to be a=
pproved
> ("Rejected. We don't recognize 5433!") and then implemented.
>=20
> Much easier to use a tablespace.

*shrug* Sure, there are entities that think that security and professionali=
sm can be
measured in how difficult you are making everybody's life.  If rules and re=
gulations
are in the way of choosing the best solution, you have to go for the second=
 best one.

Yours,
Laurenz Albe