On 13/01/2010 1:31 PM, Dave Page wrote:
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.
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
