Re: Database in another drive - Mailing list pgsql-general

From Ron Johnson
Subject Re: Database in another drive
Date
Msg-id CANzqJaD5xhYqeWoszSFykag+9KE3+7q421AncMzE0p0hoRBeSA@mail.gmail.com
Whole thread Raw
In response to Database in another drive  (Arbol One <arbolone@hotmail.ca>)
Responses Re: Database in another drive
List pgsql-general
On Mon, Oct 13, 2025 at 4:19 PM Arbol One <arbolone@hotmail.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!

pgsql-general by date:

Previous
From: Tim Gerber
Date:
Subject: Re: Database in another drive
Next
From: Adrian Klaver
Date:
Subject: Re: Database in another drive