Обсуждение: MAX CONNECTIONS PROBLEM
Hi all. i have a big problem with the max-connections parameter. the default it´s 32 but i increase to 200. shutdown the machine and restart, but nothing. not work, i need more than 32 almost to 200 connections but not work have a postgresql 7.3 and redhat 8.0 thank
On Wed, Apr 23, 2003 at 12:07:03PM -0400, Mario Alberto Soto Cordones wrote: > Hi all. i have a big problem with the max-connections parameter. > > the default it?s 32 but i increase to 200. shutdown the machine and > restart, but nothing. I suspect you need to reconfigure your kernel. What errors do you get when you try 200 connections? (You shouldn't need to shut down the machine for _that_, just for reconfiguring.) A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110
On Friday 25 Apr 2003 3:00 am, Andrew Sullivan wrote: > On Wed, Apr 23, 2003 at 12:07:03PM -0400, Mario Alberto Soto Cordones wrote: > > Hi all. i have a big problem with the max-connections parameter. > > > > the default it?s 32 but i increase to 200. shutdown the machine and > > restart, but nothing. > > I suspect you need to reconfigure your kernel. reconfigure kernel ?? why you think so Regds mallah. What errors do you > get when you try 200 connections? (You shouldn't need to shut down > the machine for _that_, just for reconfiguring.) > > A -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
> > > Hi all. i have a big problem with the max-connections parameter. > > > > > > the default it?s 32 but i increase to 200. shutdown the machine > > > and restart, but nothing. > > > > I suspect you need to reconfigure your kernel. > > reconfigure kernel ?? > why you think so Lack of shared memory allocated, limits being too low, etc. Can be any one of a number of reasons but those are the most likely in this case. -sc -- Sean Chittenden
>> > > Hi all. i have a big problem with the max-connections parameter. >> > > >> > > the default it?s 32 but i increase to 200. shutdown the machine and restart, but nothing. >> > >> > I suspect you need to reconfigure your kernel. >> >> reconfigure kernel ?? >> why you think so > > Lack of shared memory allocated, limits being too low, etc. Can be any one of a number of > reasons but those are the most likely in this case. Actually his problem is solved he kindly allowed me to login and examine. The problem was hiz shared_buffers were 64 and we wanted max_connections to be 200 so shared_buffers were falling short. the postmaster was ritely complaining , but the brain dead RPM packages put redirect messages to /dev/null :( regds mallah. > > -sc > > -- > Sean Chittenden ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/