Thread

1. Database in another drive

   Arbol One <arbolone@hotmail.ca> — 2025-10-13T20:19:01Z

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

2. Re: Database in another drive

   John McKown <john.archie.mckown@gmail.com> — 2025-10-13T20:21:45Z

   https://www.google.com/search?q=create+postgres+database+on+e%3A&oq=create+postgres+database+on+e%3A&gs_lcrp=EgZjaHJvbWUyBggAEEUYOdIBCTI5MjI0ajBqN6gCD7ACAQ&client=ms-android-google&sourceid=chrome-mobile&ie=UTF-8
   
   On Mon, Oct 13, 2025, 15:19 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 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 this?
   >
   >
   >
   >
   >
   >
   >
   

3. Re: Database in another drive

   Tim Gerber <tggerber@gmail.com> — 2025-10-13T20:36:46Z

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

4. Re: Database in another drive

   Ron <ronljohnsonjr@gmail.com> — 2025-10-13T21:57:53Z

   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!
   

5. Re: Database in another drive

   Adrian Klaver <adrian.klaver@aklaver.com> — 2025-10-13T23:01:57Z

   On 10/13/25 14:57, Ron Johnson wrote:
   > On Mon, Oct 13, 2025 at 4:19 PM Arbol One <arbolone@hotmail.ca 
   > <mailto: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?
   
   Consider yourself having lived a charmed life. You don't want to have to 
   restore a Windows machine. The usual method is to start over with an OS 
   only disk image and rebuild the user data from backups.
   
   
   -- 
   Adrian Klaver
   adrian.klaver@aklaver.com