Re: Moving database cluster

> -----Mensaje original-----
> De:
>
> On Thursday 14 January 2010, Fernando Hevia elucidated thus:
> > An Ubuntu install creates a postgres cluster automatically on
> > /var/lib/postgresql/8.4/main Whats the best procedure for
> moving this
> > cluster to an other location? Should I just rerun initdb?
> What happens
> > then with the default cluster or how could I delete it?
>
> The easiest way is to shut down Pg, move the 'main' directory
> somewhere else, and then point a symlink to the new location.
>

Thanks for your reply.
I had considered this first but then I wasn't sure if there would be any
performance penalty.
The current main directory sits on a 'slow' RAID 1 volume while the new one
will sit on a 'fast' 12 disk RAID 10 volume.
I guess the symlink shouldn't be troublesome but I don't know if some PG
process will continually be reading this link encumbering somehow the RAID 1
disks.

Regards,
Fernando.