Re: [cobalt-users] Switching from MySQL to PostGreSQL

["Steven Werby" <steven@xxxxxxxxxxxx>]

Hi Doug.

> 1) How would I go about uninstalling MySQL on a RAQ2? There are no
> uninstall scripts in /var/lib/cobalt/uninstallers/ and there seems to

rpm -e "rpm_package" is the command you need to run while logged in as root.
If that doesn't work, look for the MySQL INSTALL or README files and see
what they have to say or subscribe to the MySQL mailing list.  I posted the
email address for it a couple of weeks ago and if you can't find it look on
mysql.net.

> 3) In MySQL I'm having this problem that you all have been discussing
> where PI() doesn't work right. Is this problem going to carry over to
> PostGreSQL?

I believe it's related ot the MIPS processor in the RaQ so you will most
likely have the same problem with PostGreSQL, though I have never used that
DB system.  Even if you don't plan on using PI(), SUM(), or working with
decimal numerals right now, I would fix the problem now b/c you'll likely
need to at some point.  The instructions I posted work and someone else
posted what looked to be a simpler fix.

I'm just curious, why do you want to switch to PostGreSQL?  Does it have
functionality MySQL doesn't have?  MySQL is the most widely used open source
DB platform.  And it's easily used with PHP.  Not sure about PostGreSQL
though.

Steven {steven@xxxxxxxxxxxx}