PG 7.0.3 & RH 7 IPC problems?
От | DHSC Webmaster |
---|---|
Тема | PG 7.0.3 & RH 7 IPC problems? |
Дата | |
Msg-id | 3AC350FD.877FE31D@dhs-club.com обсуждение исходный текст |
Ответы |
Re: PG 7.0.3 & RH 7 IPC problems?
|
Список | pgsql-admin |
I'm running 7.0.3 on a double pentium 733 RH 7 box with 512M ram. We quickly ran up against the default 32 max. connection limit since it is a backend DB for our web server. When trying to increase the buffers and connections as advised in the docs, I got the error: [postgres@atl01371 data]$ nohup postmaster -D /usr/local/pgsql/data -i -B 128 -N 64 > /usr/local/pgsql/data/logs/log.txt IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=2048000, permission=600 This type of error is usually caused by an improper shared memory or System V IPC semaphore configuration. For more information, see the FAQ and platform-specific FAQ's in the source directory pgsql/doc or on our web site at http://www.postgresql.org. FATAL 1: ShmemCreate: cannot create region [postgres@atl01371 data]$ Since Redhat says that version 7 supports IPC and we have increased shared memory to 128 meg without solving the problem, does anyone have a positive experience with this scenario to share? Here is a partial list from sysctl -a vm.kswapd = 512 32 32 vm.pagecache = 2 15 75 vm.buffermem = 2 10 60 vm.overcommit_memory = 0 vm.freepages = 256 512 768 kernel.sysrq = 0 kernel.shmall = 33554432 kernel.shmmax = 134217728 kernel.rtsig-max = 1024 kernel.rtsig-nr = 0 kernel.acct = 4 2 30 kernel.modprobe = /sbin/modprobe kernel.printk = 6 4 1 7 kernel.ctrl-alt-del = 0 kernel.real-root-dev = 2054 kernel.panic = 0 kernel.version = #1 SMP Mon Feb 5 14:36:22 EST 2001 kernel.osrelease = 2.2.17-14smp -- Bill MacArthur Webmaster DHS Club
В списке pgsql-admin по дате отправления: