Re: Moving database cluster

Le 14/01/2010 21:40, Fernando Hevia a écrit :
>
> 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?
>

If you don't have any data on it, the best way is to drop it with
pg_dropcluster, and create a new one with pg_createcluster.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com