Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z) - Mailing list pgsql-general

From Jasen Betts
Subject Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)
Date
Msg-id jona68$fvu$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Move the postgreSQL database from Drive C to Map Network Drive (Called Z)  (EllyR <ela_macky@yahoo.com>)
Responses Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)
List 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 by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Lock out PostgreSQL users for maintenance
Next
From: Jasen Betts
Date:
Subject: Re: Uppercase to lowercase trigger?