PostgreSQL on Windows or MS-SQLServer???

Started by Philip Hallstromabout 24 years ago2 messagesgeneral
Jump to latest
#1Philip Hallstrom
philip@adhesivemedia.com

Hi all -
We're developing a product that currently runs on freebsd, apache,
php, postgresql. I've been asked to look into what it would take to port
this product to Windows. Yes, I know all the reasons why we don't want to
do that and we're not planning on it, but if a client really wants it and
wants to pay for it, well, then we'll do it.

I've searched the lists and found a lot of "how do I install" postgres on
windows, but I haven't seen a lot of "how well does it work" posts.

Anyone care to comment on how well postgres on windows works (assuming
w2k)?

Would you recommend postgres on windows for a production environment?

Is it stable (as stable as Windows can be that is :)?

And if the above answers tend to be "no", can anyone give me a rough idea
of the pain involved in converting to MS-SQLServer? We use a lot of
triggers, keys, joins, stored procedures. I know I won't get specifics,
but just trying to get a general idea.

Thanks!

-philip

#2Command Prompt, Inc.
pgsql-general@commandprompt.com
In reply to: Philip Hallstrom (#1)
Re: PostgreSQL on Windows or MS-SQLServer???

The use of PostgreSQL on windows requires the use of Cygwin.
The performance of PostgreSQL under any noticable load on Cygwin/Win32 is
horrendous.

J

On Thu, 4 Apr 2002, Philip Hallstrom wrote:

Hi all -
We're developing a product that currently runs on freebsd, apache,
php, postgresql. I've been asked to look into what it would take to port
this product to Windows. Yes, I know all the reasons why we don't want to
do that and we're not planning on it, but if a client really wants it and
wants to pay for it, well, then we'll do it.

I've searched the lists and found a lot of "how do I install" postgres on
windows, but I haven't seen a lot of "how well does it work" posts.

Anyone care to comment on how well postgres on windows works (assuming
w2k)?

Would you recommend postgres on windows for a production environment?

Is it stable (as stable as Windows can be that is :)?

And if the above answers tend to be "no", can anyone give me a rough idea
of the pain involved in converting to MS-SQLServer? We use a lot of
triggers, keys, joins, stored procedures. I know I won't get specifics,
but just trying to get a general idea.

Thanks!

-philip

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
--
by way of pgsql-general@commandprompt.com
http://www.postgresql.info/
http://www.commandprompt.com/