Re: move database directory

Since you are using linux :-)

I have postgres in /usr/local/pgsql the default place

I was running out of room and needed to move it to /opt

The easiest way i found was to

bash$ mv /usr/local/pgsql /opt

bash$ ln -s /opt/pgsql /usr/local/pgsql

This will create the symbolic link and therefore postgres will be none the
wiser that infact its directory has changed

You do not even need to do anything to the database except stop it before
you move and then restart it once you have moved

Darren Ferguson

On Wed, 6 Mar 2002, Johnson, Shaunn wrote:

> 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.
>
> I don't supposed there is a 'howto' and 'reminder'
> for pulling off such things, is there?  As I've
> never done this before, I keep thinking that
> there is more to it than remapping the
> postmaster from startup and vacuum analyze
> all of the tables after the move.
>
> Any suggestions / documentation about such
> matters?
>
> Thanks!
>
> -X
>