MIME-Version: 1.0
References: <AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com>
 <CAKoxK+4RTRP+phsnJgMjVzFVjmAHdu2wCXG_5YtsFR_fJEY6_Q@mail.gmail.com> <7002449259b582723ed7e041a7f0de116b48ad4d.camel@cybertec.at>
In-Reply-To: <7002449259b582723ed7e041a7f0de116b48ad4d.camel@cybertec.at>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 17 Mar 2025 14:33:52 -0400
Message-ID: <CANzqJaCZH2KmjOpAWXA=jUb-+He0D68sgY-YTibjk4bmH5Qt0A@mail.gmail.com>
Subject: Re: Creating a new database on a different file system
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004d729f06308e087c"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCZH2KmjOpAWXA%3DjUb-%2BHe0D68sgY-YTibjk4bmH5Qt0A%40mail.gmail.com>
Precedence: bulk

--0000000000004d729f06308e087c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Mar 17, 2025 at 11:18=E2=80=AFAM Laurenz Albe <laurenz.albe@cyberte=
c.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@bankze=
ro.co.za>
> wrote:
> > > We have created a few databases on the file system defined in the
> postgresql.conf,
> > > but now I would like to create another database within the same
> cluster but on a
> > > different file system.
> > >
> > > Is this possible and if so, how do we go about it.
> >
> > 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.
>

That of course requires using another port, which can be tricky in a
company 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 approved ("Rejected. We don't
recognize 5433!") and then implemented.

Much easier to use a tablespace.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000004d729f06308e087c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Mar 17, 2025 at 11:18=E2=80=AFAM =
Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@c=
ybertec.at</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contai=
ner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">On Mon, 2025-03-17 a=
t 15:51 +0100, Luca Ferrari wrote:<br>
&gt; On Mon, Mar 17, 2025 at 3:49=E2=80=AFPM Ian Dauncey &lt;<a href=3D"mai=
lto:Ian.Dauncey@bankzero.co.za" target=3D"_blank">Ian.Dauncey@bankzero.co.z=
a</a>&gt; wrote:<br>
&gt; &gt; We have created a few databases on the file system defined in the=
 postgresql.conf,<br>
&gt; &gt; but now I would like to create another database within the same c=
luster but on a<br>
&gt; &gt; different file system.<br>
&gt; &gt; <br>
&gt; &gt; Is this possible and if so, how do we go about it.<br>
&gt; <br>
&gt; create a tablespace on the filesystem you want to use, and then create=
<br>
&gt; the database adding the `WITH TABLESPACE` clause.<br>
&gt; See &lt;<a href=3D"https://www.postgresql.org/docs/17/sql-createtables=
pace.html" rel=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/=
docs/17/sql-createtablespace.html</a>&gt;<br>
<br>
That is an option, but I would recommend to create a new database cluster<b=
r>
on the new file system rather than creating a tablespace.<br></blockquote><=
div><br></div><div>That of course requires using another port, which can be=
 tricky in a company that by default closes all firewall ports at the netwo=
rk switch level, and where you must enumerate every server/subnet (&quot;Re=
jected. Subnet range too broad!&quot;) that needs access to the new port, i=
t takes time for requests for new port openings to be approved (&quot;Rejec=
ted. We don&#39;t recognize 5433!&quot;) and then implemented.</div><div><b=
r></div><div>Much easier to use a tablespace.</div><div><br></div></div><sp=
an class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D=
"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sa=
uce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&=
gt; lobster!</div></div></div></div></div></div>

--0000000000004d729f06308e087c--