At 17.37 25/11/2002, you wrote: >Fabio, > >I've thought about running PostgresQL on Windoes using CygWin. Do you know >what kind of performance you can get out of this configuration? Can you use >Jdbc drivers to talk to this postgres db?
I don't know about performance because I use this kind of configuration only when I develop on my own machine. I can say that PG on Win is much slower than on a Linux Box, mainly when I do a lot of bulk insert. I use ODBC driver with CF 5 and JDBC driver with CFMX. The only problem I had was with CFMX pre update, for the charset encoding. With the update I solved all problems defining the charset in the connection path: jdbc:postgresql://localhost/myDB?charSet=ISO8859_1 I wrote an article about installing PG+CFMX+Win but it's in italian :-( : http://www.cfmentor.com/doc/index.cfm?action=articolo&id=50 Jochem van Dieten wrote a great tutorial with all steps necessary to use CFMX with PG. http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=15 He is an expert about PG+CF and I think he reads this ML. He also told me that a native porting of PG on Windows is coming :-) If you want to use PG on Win you need Cywing, here I found useful information for installing Cygwin and configuring PG: http://www.gasai.com/gisapps/windowsHowTo.html anyway the procedure is very simple: 3 or 4 click, no more :-) I have never had any issues to port an application from win+pg to linux+pg, but I have to say tha my experience is mostly with CF 5. Regards -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available -------------------------------------------------- ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
