Re: [GENERAL] Moving database cluster

2010-01-14 Thread David Kerr
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 - > > /

Re: [GENERAL] Moving database cluster

2010-01-14 Thread Joshua J. Kugler
On Thursday 14 January 2010, Fernando Hevia elucidated thus: > > 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 pe

Re: [GENERAL] Moving database cluster

2010-01-14 Thread Fernando Hevia
> -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 r

Re: [GENERAL] Moving database cluster

2010-01-14 Thread Fernando Hevia
> -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 > > clust

Re: [GENERAL] Moving database cluster

2010-01-14 Thread Joshua J. Kugler
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 clu

Re: [GENERAL] Moving database cluster

2010-01-14 Thread Guillaume Lelarge
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

[GENERAL] Moving database cluster

2010-01-14 Thread Fernando Hevia
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? Thanks, Fernando. -- Sent via pgsql