Thread: PostgreSQL or mySQL

PostgreSQL or mySQL

From
"Kirti S. Bajwa"
Date:

Hello List:

 

I hope my question does not start war of the posts. This question is genuine. Please answer objectively:

 

I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS, Apache, (mySQL & PostgreeSQL), PHP, Postfix, etc. This Master Server will have all the software I we need for our operation. We will copy MS to each server and setup a load balancing servers.

 

I have very little knowledge of either PostgreeSQL or mySQL. Please advise me as to which of these two software package to use? I need some specific examples as to superiority of one package over the other. I prefer using the package which has a goof GUI database design.

 

Please help. I am posting this message to both lists. I am specifically interested in opinion of system analysts who have used both of these packages.

 

Thanks.

 

Kirti

Re: PostgreSQL or mySQL

From
Richard Broersma Jr
Date:
> I hope my question does not start war of the posts. This question is
> genuine. Please answer objectively:
> I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS,
> Apache, (mySQL & PostgreeSQL), PHP, Postfix, etc. This Master Server will
> have all the software I we need for our operation. We will copy MS to each
> server and setup a load balancing servers.
> I have very little knowledge of either PostgreeSQL or mySQL. Please advise
> me as to which of these two software package to use? I need some specific
> examples as to superiority of one package over the other. I prefer using the
> package which has a goof GUI database design.
> Please help. I am posting this message to both lists. I am specifically
> interested in opinion of system analysts who have used both of these
> packages.

I am not the experienced analyst that you seek.  But there are many threads generated by such ones
on this very topic:

Here is one such thread: (there are many others if you care to search for them :-) )
http://archives.postgresql.org/pgsql-general/2006-03/msg01004.php

Regards,

Richard Broersma Jr.

Re: PostgreSQL or mySQL

From
"Guy Rouillier"
Date:
Kirti S. Bajwa wrote:
> Hello List:
>
> I hope my question does not start war of the posts. This question is
> genuine. Please answer objectively:
>
> I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS,
> DNS, Apache, (mySQL & PostgreeSQL), PHP, Postfix, etc. This Master
> Server will have all the software I we need for our operation. We
> will copy MS to each server and setup a load balancing servers.
>
> I have very little knowledge of either PostgreeSQL or mySQL. Please
> advise me as to which of these two software package to use? I need
> some specific examples as to superiority of one package over the
> other. I prefer using the package which has a goof GUI database
> design.
>
> Please help. I am posting this message to both lists. I am
> specifically interested in opinion of system analysts who have used
> both of these packages.

This topic arises on almost a weekly basis.  Have you read the archives?
Do you have specific questions after having read the archives?

You say absolutely nothing about your application.  Neither PostgreSQL
nor MySQL is completely superior to the other in all circumstances.  If
such were the case, both projects being open source, the superior one
would been universally adopted and the inferior one would have
disappeared.  Since that hasn't happened, you can probably safely assume
that MySQL is good for some applications, and PostgreSQL is good for
some applications.

If your question truly is genuine, and you've done some reading, post
back with some more specifics that people can comment on with some
relevance.

--
Guy Rouillier