I used the windows version of PostgreSQL on a pretty big project last year. The deployment was on *nix, but I was developing on Windows.
The only gotcha I ran into was that the pid file sometimes got left behind if PostgreSQL terminated unexpectedly. That resulted in me not being able to start the PostgreSQL service. The first couple of times that happened I ended up reinstalling PostgreSQL, but the third time I decide to find out exactly what was causing the issue. From what I remember the file is postmaster.pid and is in the data sub-directory of the postgreSQL install. Deleting the file solves the problem. I'm not sure if that issue is fixed in the latest release of the windows install, but I thought I'd save you the pain if it isn't ;) Spike S. Isaac Dealey wrote: >>One is the obvious question of, have you thought of >>PostgreSQL? It is >>much more feature rich than MySQL and is now also a native >>Windows app >>with version 8 (previously it wasn't, at least as >>standard). > > >>-- >>Damien McKenna - Web Developer - >>[EMAIL PROTECTED] >>The Limu Company - http://www.thelimucompany.com/ - >>407-804-1014 >>#include <stdjoke.h> > > > Oh sweet... The last time I looked it seemed like their windows port > was way off in the distance, like dreams of taking a shuttle-ride to > Mars for vacation. I've just never really got the time or the money to > set up a 2nd machine at home (yes, I know about vpc) to try and test > with PostgreSQL but now that the windows port is available, I'll > probably see about testing the onTap framework with it like I wanted > to a while back. It already supports MS SQL, MySQL, Oracle and MS > Access. > > > s. isaac dealey 954.927.5117 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > http://www.fusiontap.com > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54