Thread: Shall I use pgsql on Windows for a productive system?

Shall I use pgsql on Windows for a productive system?

From
"Martin Schmiedel"
Date:

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

 

 

Re: Shall I use pgsql on Windows for a productive system?

From
"joek hondius"
Date:
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