...

Поиск
Список
Период
Сортировка
От John R Pierce
Тема ...
Дата
Msg-id 4B1D4D07.8040808@hogranch.com
обсуждение исходный текст
Ответ на Add pg server to cluster  (AlannY <m@alanny.ru>)
Список pgsql-general
AlannY wrote:
> Hi there.
>
> I'm using PostgreSQL as my main database engine. Everything works.
>
> I have one server for PostgreSQL, and space on it are lowing down.
>
> I want to buy a new server and somehow connect it with first one, that
> PostgreSQL will use this new server's HDD. I don't want to buy new HDD
> for the first server, because I don't have a space in server box.
>

For the requirements you've given above, buy an external storage array
instead of a new server  put a SAS card in your server, and a SAS/SATA
bay as large as you need for additional disks.    once these additional
disks are formatted and mounted as a file system, which I'm going to
call /u00 here, I'd do something like...

    1) shut down postgres
    2) mv /var/lib/pgsql/data /u00/pgdata
    3) ln -s /u00/pgdata /var/lib/pgsql
    4) restart postgres

and poof, LOTS of space.

example such enclosure, this one holds 12 3.5" SAS/SATA drives in a 2U
chassis, and is strictly something I googled, I have no experience with
the vendor or OEM
http://www.aicipc.com/ProductDetail.aspx?ref=XJ1100%20series%20-%202U%2012-bay
I would format a unit like this as raid10 using your OS's native raid
(mdadm on linux, zpool on solaris, etc).

for the SAS card, I'd lean towards a LSI Logic, such as
http://www.lsi.com/storage_home/products_home/host_bus_adapters/sas_hbas/external/sas9200-8e/index.html




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

Предыдущее
От: Scott Mead
Дата:
Сообщение: Re: Add pg server to cluster
Следующее
От: AlannY
Дата:
Сообщение: Re: Add pg server to cluster