From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Database in another drive |
Date: | 2025-10-13 21:57:53 |
Message-ID: | CANzqJaD5xhYqeWoszSFykag+9KE3+7q421AncMzE0p0hoRBeSA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Oct 13, 2025 at 4:19 PM Arbol One <arbolone(at)hotmail(dot)ca> wrote:
> 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 this?
>
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
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2025-10-13 22:11:38 | Re: Clarification on Role Access Rights to Table Indexes |
Previous Message | Tom Lane | 2025-10-13 21:21:07 | Re: Clarification on Role Access Rights to Table Indexes |