Re: Change Hard Disc Drive

On 13/01/2010 1:31 PM, Dave Page wrote:
> On Wed, Jan 13, 2010 at 10:57 AM, Craig Ringer
> <craig@postnewspapers.com.au>  wrote:
>> Unfortunately, it doesn't. This means you need to alter the Windows service
>> directly. What you need to do is stop the PostgreSQL service, then move your
>> data directory (by default in C:\Program Files\PostgreSQL\version\data where
>> "version" is 8.4, 8.3, etc) to the new location, and finally modify the
>> command line used by the service so Pg knows where to find its data
>> directory.
>
> Or... create a new tablespace on the larger drive using pgAdmin, and
> then move large tables/indexes across by right-clicking them and
> selecting Properties, and then choosing the new tablespace.

Good point. The OP said "all databases" but that may actually not be
what they need.

In fact, having tablespaces spread across both drives should give them
some performance benefits (xlog on original drive, big tables on other
drive) ... though it *does* expose them to losing the entire cluster if
EITHER drive fails. Good backups become even more essential.

--
Craig Ringer