Re: Database in another drive

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database in another drive
Date: 2025-10-13 21:57:53
Message-ID: CANzqJaD5xhYqeWoszSFykag+9KE3+7q421AncMzE0p0hoRBeSA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 13, 2025 at 4:19 PM Arbol One <arbolone(at)hotmail(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2025-10-13 22:11:38 Re: Clarification on Role Access Rights to Table Indexes
Previous Message Tom Lane 2025-10-13 21:21:07 Re: Clarification on Role Access Rights to Table Indexes