Postgres Pro
Downloads
Home   >   mailing lists

Re: cygwin - semaphores and the postgresql config settings - Mailing list pgadmin-support

From Dave Page
Subject Re: cygwin - semaphores and the postgresql config settings
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8259D81@mail.vale-housing.co.uk
Whole thread Raw
In response to cygwin - semaphores and the postgresql config settings  ("Greg Stanley-Horn, Athena Software.net" <greg@athenasoftware.net>)
List pgadmin-support
Tree view
Hi Greg,
 
This is off-topic for this list. Please try the pgsql-cygwin@postgresql.org list - there are Cygwin experts there that should be able to help you more.
 
Regards, Dave.
-----Original Message-----
From: Greg Stanley-Horn, Athena Software.net [mailto:greg@athenasoftware.net]
Sent: 11 March 2003 15:45
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] cygwin - semaphores and the postgresql config settings

Hi - I would really appreciate any advice on how to properly set the postgresql config file regarding semaphores, max connections etc.
 
I am using cygwin and postgres on a win 2000 pro server with 1.1 ghz processor and 1 gig of ram - there are about 20 users connecting to the system. About once a week, the database stops "saving" and we get the "ERROR: cannot create semaphore...no room on device" message. We currently have the max connections at 384 and the shared memory at 1024. 
 
Can anyone please provide some guidance on the proper setttings for this environment? I know it is better to switch to linux but we want to exhaust our options on configuring the windows box first.
 
Thanks, Greg
 
 
 
Greg Stanley-Horn, President
Athena Software.net
39 Brock Rd. South
Aberfoyle, ON N1H 6H9
519.572.6425

 

Attachment

pgadmin-support by date:

Previous
From: "Greg Stanley-Horn, Athena Software.net"
Date:
Subject: cygwin - semaphores and the postgresql config settings
Next
From: "Greg Stanley-Horn, Athena Software.net"
Date:
Subject: cygwin and postgresql config question