A. Kretschmer wrote:
> In response to Ivan Voras :
>
>> * buy external storage (NAS, or even an external USB drive), move the
>> database to it
>>
>
> buy external USB-Drive, and create a new tablespace, and move some large
> table into this new tablespace and/or use the new tablespace for new
> tables. You can also use table-partitioning with different tablespaces.
>
Can you then unmount that USB drive without causing any damage to the
other databases?
--
- Bill Thoen
GISnet - www.gisnet.com
303-786-9961
In response to
Responses
pgsql-general by date
| Next: | From: A. Kretschmer | Date: 2010-07-26 12:15:09 |
| Subject: Re: What to do if space for database decrease and no additional hard drive is possible? |
| Previous: | From: Vincenzo Romano | Date: 2010-07-26 12:09:23 |
| Subject: Re: What to do if space for database decrease and no additional hard drive is possible? |