From: | Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com> |
---|---|
To: | erobles <erobles(at)sensacd(dot)com(dot)mx>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connection's limit in SCO OpenServer 5.0.7 and pg 8.3.11 (no more than 94 connections) |
Date: | 2010-06-04 19:37:03 |
Message-ID: | AANLkTikQn2Anvy9QG6vStS7MmNPC-bOYxtEvKLO8boHC@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
1. What kind of error you get when client tries to establish 95th
connection? 2. Did you try to consult sco expert? The problem seems to
be not caused by postgres...
2010/6/4, erobles <erobles(at)sensacd(dot)com(dot)mx>:
> Hello! I have postgres running on SCO OpenServer 5.0.7
>
> and I've noticed that only accepts up to 94 connections, no more ...
> I modified the values in postgresql.conf
> max_connections from 100 to 128
> shared_buffers from 24 to 48 MB
>
> postgres is started with:
> su - postgres -c "/usr/local/pgsql83/bin/postmaster -i -D
> /usr/local/pgsql83/data"
>
>
>
>
> I rebuilt the SCO kernel with these values:
>
>
> NODE "srvr83"
> EVDEVS 96
> EVQUEUES 88
> NSPTTYS 64
> NUMSP 256
> NSTREAM 4352
> NHINODE 1024
> GPGSLO 2000
> GPGSHI 6000
> NSTRPAGES 6000
> NAIOPROC 50
> NAIOREQ 400
> NAIOBUF 400
> NAIOHBUF 100
> NAIOREQPP 400
> NAIOLOCKTBL 50
> MAX_PROC 10000
> MAXUMEM 1048576
> NCALL 256
> NCLIST 512
> NSTREVENT 14848
> NUMTIM 1888
> NUMTRW 1888
> SDSKOUT 64
> TTHOG 4096
> SECLUID 0
> SECSTOPIO 1
> SECCLEARID 1
>
> by the way the following variables have been established to the maximum
> SEMMAP 8192
> SEMMNI 8192
> SEMMNS 8192
> SEMMSL 300
> SEMMNU 100
> SHMMAX 2147483647
>
>
> Any reply will be highly appreciated!
>
>
> regards.
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Wysłane z mojego urządzenia przenośnego
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Eliot Gable | 2010-06-04 20:13:28 | Re: cannot assign non-composite value to a row variable |
Previous Message | raghavendra t | 2010-06-04 17:50:12 | Re: How do we get the Client-Time and Server-Time from psql ? |