Re: move database directory - Mailing list pgsql-general

From Doug McNaught
Subject Re: move database directory
Date
Msg-id m3u1rtbdf1.fsf@varsoon.denali.to
Whole thread Raw
In response to move database directory  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
"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...

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: move database directory
Next
From: Darren Ferguson
Date:
Subject: Re: move database directory