Connection's limit in SCO OpenServer 5.0.7 and pg 8.3.11 (no more than 94 connections)

Поиск
Список
Период
Сортировка
От erobles
Тема Connection's limit in SCO OpenServer 5.0.7 and pg 8.3.11 (no more than 94 connections)
Дата
Msg-id 4C0920FF.1000607@sensacd.com.mx
обсуждение исходный текст
Ответы Re: Connection's limit in SCO OpenServer 5.0.7 and pg 8.3.11 (no more than 94 connections)  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Re: Connection's limit in SCO OpenServer 5.0.7 and pg 8.3.11 (no more than 94 connections)  (Joshua Tolley <eggyknap@gmail.com>)
Список pgsql-general
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.




В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: cannot assign non-composite value to a row variable
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: How can I run an external program from a stored procedure?