PostgreSQL 의 기본설정이 32개로 되어 있어서 그런것일 겁니다.

구동 스크립트에서 -N 옵션에 적당한 숫자로 최대접속 숫자를

늘려서 운영해보시기 바랍니다.

-- 한성호 님이 쓰신 글:

>> 안녕하세요.

>>

>> 데몬이 32개만 되면 이상현상이 나타나네요.

>>

>> 디비접속도 안되고, 디비도 정지하려면 실패라고 나오고...

>>

>> 무엇보다도 디비에 있는 내용들을 잘 못끌어 옵니다.

>>

>> 게시판글의 숫자들이 0부터 -를 붙여붙거나 못불러오는 경우가 많아요.

>>

>> 떠있는 데몬들입니다.

>>

>> init-+-atd

>> |-automount

>> |-bdflush

>> |-crond---crond---run-parts---awk

>> |-gpm

>> |-java---java---34*[java]

>> |-kdm-+-X

>> | `-kdm

>> |-keventd

>> |-klogd

>> |-kreclaimd

>> |-kswapd

>> |-kupdated

>> |-mdrecoveryd

>> |-6*[mingetty]

>> |-nmbd

>> |-portmap

>> |-rpc.statd

>> |-sa1---sadc

>> |-sendmail

>> |-smbd

>> |-sshd---sshd---bash---su---bash---pstree

>> |-su---csh---postmaster---32*[postmaster] <--요부분

>> |-syslogd

>> |-2*[xfs]

>> `-xinetd

>>

>>

>> 아래의 1234번을 종료하니 데몬이 싹 죽는군요.

>>

>> postgres 1336 0.0 1.1 9740 5900 ? S Apr09 5:49 postgres: postgres xxxxx 127.0.0.1 UPDATE waiting

>> postgres 1337 0.0 1.1 9300 6096 ? S Apr09 0:30 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 1341 0.0 1.1 9300 6072 ? S Apr09 0:35 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 1367 0.0 1.1 9200 5924 ? S Apr09 4:32 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2289 0.0 1.1 9180 5972 ? S Apr09 4:13 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2727 0.2 1.2 9260 6296 ? S Apr09 14:24 postgres: postgres xxxxx 127.0.0.1 idle in transaction

>> postgres 2730 0.0 1.1 9692 5960 ? S Apr09 5:53 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2731 0.0 1.1 9232 6048 ? S Apr09 4:36 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2732 0.0 1.1 9344 6096 ? S Apr09 3:14 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2735 0.0 1.1 9736 5964 ? S Apr09 5:12 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2766 0.1 1.1 9756 6136 ? S Apr09 9:07 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2767 0.0 1.1 9192 6004 ? S Apr09 5:42 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2768 0.0 1.1 9220 6040 ? S Apr09 4:19 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2769 0.0 1.1 9212 5972 ? S Apr09 3:17 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2770 0.2 1.1 9808 6068 ? S Apr09 16:07 postgres: postgres xxxxx 127.0.0.1 idle in transaction

>> postgres 2771 0.0 1.1 9172 5952 ? S Apr09 3:21 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 2772 0.1 1.1 9704 6056 ? S Apr09 8:27 postgres: postgres xxxxx 127.0.0.1 UPDATE waiting

>> postgres 2773 0.0 1.1 9172 5908 ? S Apr09 2:29 postgres: postgres xxxxx 127.0.0.1 UPDATE waiting

>> postgres 2774 0.0 1.2 9224 6168 ? S Apr09 5:56 postgres: postgres xxxxx 127.0.0.1 UPDATE waiting

>> postgres 2775 0.0 1.1 9808 6064 ? S Apr09 5:45 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 3322 0.0 1.1 9284 6048 ? S Apr09 0:31 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 13925 0.0 1.1 9312 6096 ? S Apr10 0:12 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 22398 0.0 1.2 9268 6168 ? S Apr11 0:10 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 22405 0.0 1.1 9240 6144 ? S Apr11 0:09 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 22406 0.0 1.2 9312 6224 ? S Apr11 0:10 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 22407 0.0 1.2 9260 6304 ? S Apr11 0:09 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 22410 0.0 1.2 9284 6340 ? S Apr11 0:09 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 24830 0.0 0.3 9128 1924 ? S Apr11 0:02 postgres: postgres xxxxx 127.0.0.1 idle

>> postgres 29011 0.0 1.1 9300 6012 ? S Apr11 0:48 postgres: postgres xxxxx 127.0.0.1 UPDATE waiting

>> postgres 29013 0.1 1.1 9204 6116 ? S Apr11 4:13 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>> postgres 29868 0.0 1.1 9296 5900 ? S Apr11 2:21 postgres: postgres xxxxx 127.0.0.1 UPDATE waiting

>> postgres 1234 0.1 1.2 9252 6392 ? S Apr11 4:17 postgres: postgres xxxxx 127.0.0.1 INSERT waiting

>>

>> 그 후 디비 정지시키고 리스타팅하니 잘 되고...

>>

>> 초보라 분석도 잘 못해서리...

>>

>> 조언 부탁드립니다.