Обсуждение: Database in another drive
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?
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?
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?
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!
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