Re: Need suggestions

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема Re: Need suggestions
Дата
Msg-id 92869e660906260755k545ae74cmb0c055885107e9cb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need suggestions  (Jack W <dbdevelop2000@gmail.com>)
Список pgsql-general


2009/6/25 Jack W <dbdevelop2000@gmail.com>

Maybe for maintainence purpose or schema change. For example as you mentioned above, if using several tablespaces located on different hard drives. If one hard drive is damaged, the database on that hard drive will not be available. How about other databases managed by the same database server instance?

interesting questions...

If I were you, I would just verify this by creating separate partition, putting a tablespace there, creating a database in this tablespace, pgbench'ing this database continuosly, and running
umount --force on the partition.

 
I need to shut down all the databases to do mainatainence, right?   

depends on the kind of maintenance.


--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can't start postgresql 8.3.7
Следующее
От: David Fetter
Дата:
Сообщение: Re: masking the code