On Thu, Jan 14, 2010 at 06:21:14PM -0300, Fernando Hevia wrote: - - - > -----Mensaje original----- - > De: Guillaume Lelarge [mailto:guilla...@lelarge.info] - > - > 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. - > - > - - Sound advice. Thanks!!
in SLES, assuming you have no data in the DB, I'd go to /etc/sysconfig/postgresql modify POSTGRES_DATADIR="/my/new/path" and then (logout/log back in to get your PGDATA set correctly and ) initdb No need to mess with symlinks. I'm sure ubuntu has something similar to sysconfig Dave -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
