...
От | 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 по дате отправления: