MIME-Version: 1.0
References: <BYAPR12MB2808D1E14F64E4E1CD45DD19BAEAA@BYAPR12MB2808.namprd12.prod.outlook.com>
In-Reply-To: <BYAPR12MB2808D1E14F64E4E1CD45DD19BAEAA@BYAPR12MB2808.namprd12.prod.outlook.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 13 Oct 2025 17:57:53 -0400
Message-ID: <CANzqJaD5xhYqeWoszSFykag+9KE3+7q421AncMzE0p0hoRBeSA@mail.gmail.com>
Subject: Re: Database in another drive
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009ba3290641115cc6"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaD5xhYqeWoszSFykag%2B9KE3%2B7q421AncMzE0p0hoRBeSA%40mail.gmail.com>
Precedence: bulk

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

On Mon, Oct 13, 2025 at 4: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've been using Windows on (local, telecommuting) corporate PCs for 25
years.  Never has the hardware crashed or Windows become so corrupted that
C: needed to be wiped?


> I lost all kinds of information including PostgreSQL (postgres
> (PostgreSQL) 18.0), its databases, tables, data, etc., what a nightmare!
>

Where are your backups?  Why don't you have backups?


> 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?
>

Of course.  The same way you created them on C:.  Either with a GUI or
command prompt.
mkdir E:\PosgreSQL\data
initdb -k -D  E:\PosgreSQL\data

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Oct 13, 2025 at 4:19=E2=80=AFPM A=
rbol One &lt;<a href=3D"mailto:arbolone@hotmail.ca">arbolone@hotmail.ca</a>=
&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquo=
te 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"msg15314833223698703=
08">


<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;</div></div></div></blockquote><div><br></div><div>I&#39=
;ve been using Windows on (local, telecommuting) corporate PCs for 25 years=
.=C2=A0 Never has the hardware crashed or Windows become so corrupted that =
C: needed to be wiped?</div><div>=C2=A0</div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div class=3D"msg1531483322369870308"><div dir=3D"ltr">=
<div> 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)">p=
ostgres
 (PostgreSQL) 18.0), its databases, tables, data, etc., what a nightmare!</=
span></div></div></div></blockquote><div><br></div><div>Where are your back=
ups?=C2=A0 Why don&#39;t you have backups?</div><div>=C2=A0</div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex"><div class=3D"msg153148332236987030=
8"><div dir=3D"ltr">
<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></div></div></div></blockquote><di=
v>=C2=A0</div></div><div>Of course.=C2=A0 The same way you created them on =
C:.=C2=A0 Either with a GUI or command prompt.</div><div>mkdir E:\PosgreSQL=
\data</div><div>initdb -k -D=C2=A0

E:\PosgreSQL\data

</div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><=
div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Red=
acted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br=
><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--0000000000009ba3290641115cc6--