MIME-Version: 1.0
References: <BYAPR12MB2808D1E14F64E4E1CD45DD19BAEAA@BYAPR12MB2808.namprd12.prod.outlook.com>
In-Reply-To: <BYAPR12MB2808D1E14F64E4E1CD45DD19BAEAA@BYAPR12MB2808.namprd12.prod.outlook.com>
From: Tim Gerber <tggerber@gmail.com>
Date: Mon, 13 Oct 2025 15:36:46 -0500
Message-ID: <CAPKih1xMPydbEtXtTOjxZbPC+ULuzJcX1WN-j-NVcX8urjo69w@mail.gmail.com>
Subject: Re: Database in another drive
To: Arbol One <arbolone@hotmail.ca>
Cc: PostGreSQL MailingList <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009124e60641103a60"
Archived-At: <https://www.postgresql.org/message-id/CAPKih1xMPydbEtXtTOjxZbPC%2BULuzJcX1WN-j-NVcX8urjo69w%40mail.gmail.com>
Precedence: bulk

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

Yes, you can either set the default tablespace to the desired drive or
create a tablespace on the E: drive and specify the db objects to use it.
Best to look at:
https://www.postgresql.org/docs/current/manage-ag-tablespaces.html

Best Regards,
Tim

On Mon, Oct 13, 2025 at 3:19=E2=80=AFPM Arbol One <arbolone@hotmail.ca> wro=
te:

> Is there a way to either create the database or save the data in another
> drive?
>
> I am using Win11, not my choice since 1998, and, not surprisingly, the
> WinOS had a crash; I lost all kinds of information including PostgreSQL (=
postgres
> (PostgreSQL) 18.0), its databases, tables, data, etc., what a nightmare!
> To not have this happen again, I'd like to create the databases in the E:
> drive or have the tables stored in that drive, please note that I am not
> talking about backing the data in the E: drive, but to actually have the
> databases in the E: drive. Can this be done and is it practical to do thi=
s?
>
>
>
>
>
>
>

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

<div dir=3D"ltr">Yes, you can either set the default tablespace to the desi=
red drive or create a tablespace on the E: drive and specify the db objects=
 to use it.=C2=A0 Best to look at:=C2=A0=C2=A0<a href=3D"https://www.postgr=
esql.org/docs/current/manage-ag-tablespaces.html">https://www.postgresql.or=
g/docs/current/manage-ag-tablespaces.html</a><div><br></div><div>Best Regar=
ds,</div><div>Tim</div></div><br><div class=3D"gmail_quote gmail_quote_cont=
ainer"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Oct 13, 2025 at 3:19=
=E2=80=AFPM Arbol One &lt;<a href=3D"mailto:arbolone@hotmail.ca">arbolone@h=
otmail.ca</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div class=3D"msg6235349303507151737">


<div dir=3D"ltr">
<div>Is there a way to either create the database <span style=3D"font-famil=
y:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
or save the data in</span>=C2=A0another drive?<br>
<br>
</div>
<div>I am using Win11, not my choice since 1998, and, not surprisingly, the=
 WinOS had a crash; I lost all kinds of information including PostgreSQL (<=
span style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">postgres
 (PostgreSQL) 18.0), its databases, tables, data, etc., what a nightmare!</=
span></div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
To not have this happen again, I&#39;d like to create the databases in the =
E: drive or have the tables stored in that drive, please note that I am not=
 talking about backing the data in the E: drive, but to actually have the d=
atabases in the E: drive. Can this be
 done and is it practical to do this?<br>
<br>
<br>
</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
<br>
</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
</div>
</div>

</div></blockquote></div>

--0000000000009124e60641103a60--