Re: Change Hard Disc Drive

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.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com