Re: Installing Postgres 8.1 on Windows Server 2003 R2

Carl Conard wrote:
> I've successfully installed Postgres 8.1.2 on WS 2003 R2 on a Lenovo
> (IBM) ThinkPad.  I used the default installation options and everything
> seems peachy keen for a single user (using localhost).
>
> However, when we started performance testing Postgres (vs. MySQL) using
> a 3rd party tool (I forget the name) running on the server, Postgres
> would drop connections after about the 10th or 11th virtual user (of 20)
> hit the DB.  The remaining user processes would remain visible in
> Window's Task Manager and just "hang."

How are you connecting?
What do you mean by "drop connections"?
What do you mean by "hang" - does the server have problems shutting them
down if you tell it to?
What do the logs show?
What changes have you made to your configuration files?

--
   Richard Huxton
   Archonet Ltd