Re: Re: What to do if space for database decrease and no additional hard drive is possible?

Поиск
Список
Период
Сортировка
От Bill Thoen
Тема Re: Re: What to do if space for database decrease and no additional hard drive is possible?
Дата
Msg-id 4C4D7BDA.8040905@gisnet.com
обсуждение исходный текст
Ответ на Re: Re: What to do if space for database decrease and no additional hard drive is possible?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: Re: What to do if space for database decrease and no additional hard drive is possible?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general

A. Kretschmer wrote:
> In response to Ivan Voras :
>
>> * buy external storage (NAS, or even an external USB drive), move the
>> database to it
>>
>
> buy external USB-Drive, and create a new tablespace, and move some large
> table into this new tablespace and/or use the new tablespace for new
> tables. You can also use table-partitioning with different tablespaces.
>
Can you then unmount that USB drive without causing any damage to the
other databases?

--
- Bill Thoen
  GISnet - www.gisnet.com
  303-786-9961


В списке pgsql-general по дате отправления:

Предыдущее
От: Vincenzo Romano
Дата:
Сообщение: Re: What to do if space for database decrease and no additional hard drive is possible?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: What to do if space for database decrease and no additional hard drive is possible?