As for comparisons, that has been discussed many times. See several threads on MySQL/PostgreSQL right in this forum. Also read my comments at the end of the PHP isn't an enterprise solution
post. (it is, by the way
Also browse the PostgreSQL
forum, and you will find plenty of comparisons.
To put it in a nutshell, MySQL is getting more 'relational' features, such as transactions and foreign key constraints, but still doesn't have views, triggers, or procedures. And that's just the beginning. Really, there is no comparison
to the sophisticated things PostgreSQL is capable of.
I'm not sure I understand your second question, but both MySQL and PostgreSQL have replication capabilities. The PostgreSQL one is here
MySQL's replication solution is not quite as robust as PostgreSQL's, but it is already at a production stage, while the PostgreSQL replication system is still in Beta.
There is no binary download of PostgreSQL for Windows at the moment. Some people have managed to compile PostgreSQL from the source code with Visual C++, but the easier way is to use Cygwin
, which gives your Windows machine a Unix-compatible shell, and includes a copy of PostgreSQL. There is a project to make a more Windows-compatible version of PostgreSQL, but it will probably take a few months.
Really, I don't recommend using PostgreSQL on Windows. Have a Linux or Unix server, and use the ODBC
client for Windows desktops to access the database. If a Windows server is required, then you are better off using MySQL, for now.