RE: [cobalt-users] Moving PostgreSQL

["James Hurst" <james@xxxxxxxxxxxxxxxxxxxxxxxx>]

> Why not shutdown PostgreSQL, backup the directory, move the
> original to the
> new location, create the symlink, restart PostgreSQL and see what happens?
> If it doesn't work, undo the changes and put the directory back in its
> original location.  That would be a whole lot faster than asking here and
> waiting and there's not really any risk.

Well, I just tried this, and postgres wouldn't start. Forgive me for being
slightly paranoid, but I immediately moved everything back and restarted
rather than looking any further into solving the problem.

> I assume Gavin had a reason for selecting PostgreSQL over MySQL.
> There are
> definitely software applications where it's a better fit.  If you
> don't want
> to use the pre-installed PostgreSQL because you're worried that it might
> affect the GUI or you want to compile a newer version of PostgreSQL with
> different features, install a second copy and use it for your
> project.  Just
> configure it to run on a different port and use a different socket file.

OK, this sounds like a good idea. Cheers.

James Hurst.
// mailto:james@xxxxxxxxxxxxxxxxxxxxxxxx
// "..in a world without boundaries or fences, who
// needs Gates anyway?"