Re: move database directory

"Johnson, Shaunn" <SJohnson6@bcbsm.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...