Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: What to do if space for database decrease and no additional hard drive is possible? - Mailing list pgsql-general

From Bill Thoen
Subject Re: Re: What to do if space for database decrease and no additional hard drive is possible?
Date
Msg-id 4C4D7BDA.8040905@gisnet.com
Whole thread Raw
In response to Re: Re: What to do if space for database decrease and no additional hard drive is possible?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Re: What to do if space for database decrease and no additional hard drive is possible?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: What to do if space for database decrease and no additional hard drive is possible?
Next
From: "A. Kretschmer"
Date:
Subject: Re: What to do if space for database decrease and no additional hard drive is possible?