Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)
Дата
Msg-id jona68$fvu$2@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Move the postgreSQL database from Drive C to Map Network Drive (Called Z)  (EllyR <ela_macky@yahoo.com>)
Ответы Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)  (EllyR <ela_macky@yahoo.com>)
Список pgsql-general
On 2012-05-04, John R Pierce <pierce@hogranch.com> wrote:
> On 05/03/12 10:18 PM, David Johnston wrote:
>> On May 3, 2012, at 20:20, EllyR<ela_macky@yahoo.com>  wrote:
>>
>>> >  Yes you are right, I have read that it is not that reliable, but I have to do
>>> >  something for that, what would be your suggestion for this case? Thanks.
>> Simplest option: install a new local hard drive and configure a tablespace to use it.
>>
>> Alternative: Buy and configure a new machine then dump/restore your database to it.
>
> or, if your NAS/SAN supports it, configure an ISCSI device.   except, I
> find ad-hoc ISCSI is not very reliable.

Some NASs even run postgresql internally, they may not have enough ram
for extreme performance, but if data volumne is the only issue that
could be a win.

--
⚂⚃ 100% natural

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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Lock out PostgreSQL users for maintenance
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Uppercase to lowercase trigger?