Re: Database in another drive
| От | Ron Johnson |
|---|---|
| Тема | Re: Database in another drive |
| Дата | |
| Msg-id | CANzqJaD5xhYqeWoszSFykag+9KE3+7q421AncMzE0p0hoRBeSA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Database in another drive (Arbol One <arbolone@hotmail.ca>) |
| Ответы |
Re: Database in another drive
|
| Список | pgsql-general |
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!
В списке pgsql-general по дате отправления: