[KLUG Members] Postgresql

[Adam Williams6]

>Greetings once again..  Question.
>My company has an app that runs using PHP and postgresql.  We are thinking
>of marketing it and selling it to customers. They would buy the prog, set
>up their own server, and install and run the app.
>My question:
>Obviously, PHP and Postgres run excellent on linux.  However, the issue
>with me is:  What happens when I get the phone call that the prog has been
>sold to a windows freak?   I'm not sure it will make companies happy to
>know that they've got to run Cygwin on top of windows, and have postgres
>running inside that.  Is there a better way?  

Yes, run it on UN*X! ;)

A pre-built copy of PostgreSQL comes with the default Cygwin.  If you have 
Cygwin you have a Win32 PostgreSQL.  There is not and never will be a 
"native" port. 

>I've searched the net quite
>a bit now, and I'm not happy.  There's a bit of documentation for postgres
>on NT, but it didn't seem to be the entire postgres server side.
>My question: Have you run postgres on windows inside cygwin before?  

No, but I've talked to people who have.  They say it "works"

>My
>boss has high hopes of selling this; but the windows/postgres issue has me
>worried.

You could recode your app to use ODBC and avoid the whole issue.  Use the 
unixODBC-postgreSQL on UNIX platforms and let the Windows people shoot 
themselved with some other ODBC drivers.  Then all you need to do is 
provide the schema.

I'm horrified by the concept of windows/{insert-database-here}.  And I've 
got plenty of company at places like Oracle and IBM.

-- 
-----------------------------------------------------------
Ximian GNOME, Evolution, LTSP, and RedHat Linux + LVM & XFS
-----------------------------------------------------------