Search Postgresql Archives

Re: Change Hard Disc Drive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jan 13, 2010 at 10:57 AM, Craig Ringer
<craig@xxxxxxxxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux