| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | Yan Cheng Cheok <yccheok(at)yahoo(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Change Hard Disc Drive |
| Date: | 2010-01-13 05:31:26 |
| Message-ID: | 937d27e11001122131x3da02a05i57051f4a28617266@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jan 13, 2010 at 10:57 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2010-01-13 05:38:06 | R: Re: Weird EXECUTE ... USING behaviour |
| Previous Message | Craig Ringer | 2010-01-13 05:27:20 | Re: Change Hard Disc Drive |