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

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Move the postgreSQL database from Drive C to Map Network Drive (Called Z)
Date: 2012-05-13 03:35:36
Message-ID: jona68$fvu$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-05-04, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 05/03/12 10:18 PM, David Johnston wrote:
>> On May 3, 2012, at 20:20, EllyR<ela_macky(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2012-05-13 10:39:36 Re: Uppercase to lowercase trigger?
Previous Message Jasen Betts 2012-05-13 03:19:08 Re: Lock out PostgreSQL users for maintenance