Re: move database directory

From: Doug McNaught <doug(at)wireboard(dot)com>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: move database directory
Date: 2002-03-06 21:21:22
Message-ID: m3u1rtbdf1.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:

> Howdy:
>
> Running Postgres 7.1.3 on RedHat Linux 7.2 kernel
> 2.4.7 rev. 10.
>
> My situation is this: I'm running out of room
> on a partition where the database resides.
> I'd like to move the database directory to another
> partition.

Shouldn't be much more to it than:

1) Shut down the database
2) Copy the tree
3) Change PGDATA in your startup script
4) Restart
5) Test
6) Delete old tree

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2002-03-06 21:43:18 Re: Mandrake RPMs rebuilt
Previous Message Johnson, Shaunn 2002-03-06 20:48:23 move database directory