Thread: Shall I use pgsql on Windows for a productive system?
I am about to develop a web-based application using Java for a school, and I am still thinking about which technology I should be using for my database server. I will most surely use a WinNT, 2k or XP PC as server (I think the client will not want a dedicated server, but rather a PC that someone could use to work with, which is not a good idea but I cannot force them to use a Linux dedicated server if they don’t want to).
Now my obvious question is… Will Postgresql work fine if mounted as a productive DB server on cygwin? The traffic will not be too heavy, so I am not too much concerned about it, but rather about a stable and adequate functionality (as stable as Windows can be J).
My other option is to use MySQL 4.x (the newest available, production version), which is easy to migrate between Windows and Linux.
Recommendations are welcome.
Regards… Martin Schmiedel
I use it for (small) production. Made a custom cygwin install with only the most needed parts of cygwin. (Be sure to include the sources to comply with licence) I tested it extensively first. Made an install and mimiced heavy traffic/inserts/updates/etc. I use only standard (but complex) SQL though. Very stable. Also do the customers have not a single problem for more than a year running now. The app is used every day by lots of users. A win machine crashed, but that's win for you, db was recovered fine. BUT!! You only have 63 concurrent connections to your database. Win cannot have more than 65 processes \w the same name, and 2 are already taken. Every connection has its own process. Win does not know fork(). This can become a problem quite fast in case of a web application using non-pooled database connections. AND!! as allways you have to know what you're doing, how en why. So there is a learning curve. Greetings from Holland, J Hondius