public inbox for [email protected]help / color / mirror / Atom feed
Database in another drive 5+ messages / 5 participants [nested] [flat]
* Database in another drive @ 2025-10-13 20:19 Arbol One <[email protected]> 0 siblings, 3 replies; 5+ messages in thread From: Arbol One @ 2025-10-13 20:19 UTC (permalink / raw) To: pgsql-general 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? ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database in another drive @ 2025-10-13 20:21 John McKown <[email protected]> parent: Arbol One <[email protected]> 2 siblings, 0 replies; 5+ messages in thread From: John McKown @ 2025-10-13 20:21 UTC (permalink / raw) To: Arbol One <[email protected]>; +Cc: pgsql-general https://www.google.com/search?q=create+postgres+database+on+e%3A&oq=create+postgres+database+on+... On Mon, Oct 13, 2025, 15:19 Arbol One <[email protected]> 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? > > > > > > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database in another drive @ 2025-10-13 20:36 Tim Gerber <[email protected]> parent: Arbol One <[email protected]> 2 siblings, 0 replies; 5+ messages in thread From: Tim Gerber @ 2025-10-13 20:36 UTC (permalink / raw) To: Arbol One <[email protected]>; +Cc: pgsql-general 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 <[email protected]> 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? > > > > > > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database in another drive @ 2025-10-13 21:57 Ron Johnson <[email protected]> parent: Arbol One <[email protected]> 2 siblings, 1 reply; 5+ messages in thread From: Ron Johnson @ 2025-10-13 21:57 UTC (permalink / raw) To: pgsql-general On Mon, Oct 13, 2025 at 4:19 PM Arbol One <[email protected]> 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! ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database in another drive @ 2025-10-13 23:01 Adrian Klaver <[email protected]> parent: Ron Johnson <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Adrian Klaver @ 2025-10-13 23:01 UTC (permalink / raw) To: Ron Johnson <[email protected]>; pgsql-general On 10/13/25 14:57, Ron Johnson wrote: > On Mon, Oct 13, 2025 at 4:19 PM Arbol One <[email protected] > <mailto:[email protected]>> 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 [email protected] ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-10-13 23:01 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-10-13 20:19 Database in another drive Arbol One <[email protected]> 2025-10-13 20:21 ` John McKown <[email protected]> 2025-10-13 20:36 ` Tim Gerber <[email protected]> 2025-10-13 21:57 ` Ron Johnson <[email protected]> 2025-10-13 23:01 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox