From: | David Kerr <dmk(at)mr-paradox(dot)net> |
---|---|
To: | Fernando Hevia <fhevia(at)ip-tel(dot)com(dot)ar> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Moving database cluster |
Date: | 2010-01-14 23:55:55 |
Message-ID: | 20100114235555.GR29521@mr-paradox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jan 14, 2010 at 06:21:14PM -0300, Fernando Hevia wrote:
-
-
- > -----Mensaje original-----
- > De: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Koterov | 2010-01-15 00:01:19 | Split pg_dump dump into files and then combine it back |
Previous Message | Scott Marlowe | 2010-01-14 23:52:35 | Re: Avoid transaction abot if/when constraint violated |