Thanks Alvaro. We are using PostgreSQL 7.1 cygwin installed on Windows 2000. We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. But our application is installed in 8 / 10 PC or more than that and it opens multiple connections and it exceeds 64. Because of this the subsequent connections are failed to connect with DB from application. Please advise us on how to resolve this ?. -- Migrating to 8.1 may not be possible at this point of time due to some reasons. Regards, Ravi -----Original Message----- From: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] Sent: Monday, August 28, 2006 7:02 PM To: Ravindran G - TLS, Chennai. Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue. Ravindran G - TLS, Chennai. wrote: > I would like to talk to one of the org member in postgre about this issue. > This is critical for us. Please help. > > It will be great, if you could provide your contact number to discuss on > this. Sure, we're happy to help. You can contact several "org members" via this mailing list. What's your problem exactly? If you're finding that the 7.1 cygwin version is too slow, please consider migrating some something more recent. 8.1 runs natively on Windows, no Cygwin required. It's much faster and doesn't have that limitation on the number of connections. Please note that the name is "PostgreSQL" and is usually shortened to "Postgres". It's never "postgre". -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. DISCLAIMER The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect.
