Skip site navigation (1) Skip section navigation (2)

Re: cygwin - semaphores and the postgresql config settings

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <greg(at)athenasoftware(dot)net>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: cygwin - semaphores and the postgresql config settings
Date: 2003-03-11 20:42:09
Message-ID: (view raw or whole thread)
Lists: pgadmin-support
Hi Greg,
This is off-topic for this list. Please try the
pgsql-cygwin(at)postgresql(dot)org list - there are Cygwin experts there that
should be able to help you more.
Regards, Dave.

-----Original Message-----
From: Greg Stanley-Horn, Athena
Sent: 11 March 2003 15:45
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] cygwin - semaphores and the postgresql config

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 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 <> 
39 Brock Rd. South
Aberfoyle, ON N1H 6H9


pgadmin-support by date

Next:From: Dave PageDate: 2003-03-11 21:15:43
Subject: Re: Cannot create a table
Previous:From: FabianoDate: 2003-03-11 19:41:56
Subject: No entry to pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group