Re: Database in another drive

Поиск
Список
Период
Сортировка
От Tim Gerber
Тема Re: Database in another drive
Дата
Msg-id CAPKih1xMPydbEtXtTOjxZbPC+ULuzJcX1WN-j-NVcX8urjo69w@mail.gmail.com
обсуждение исходный текст
Ответ на Database in another drive  (Arbol One <arbolone@hotmail.ca>)
Список 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 <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 по дате отправления: