Request a Demo
Home   >   mailing lists

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

From Tim Gerber
Subject Re: Database in another drive
Date
Msg-id CAPKih1xMPydbEtXtTOjxZbPC+ULuzJcX1WN-j-NVcX8urjo69w@mail.gmail.com
Whole thread Raw
In response to Database in another drive  (Arbol One <arbolone@hotmail.ca>)
List pgsql-general
Tree view
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?






pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Option on `postgres` CLI to shutdown when there are no more active connections?
Next
From: Ron Johnson
Date:
Subject: Re: Database in another drive