You need to increase your max backends. The default for 6.4.2 was 64. I believe it is a configure option (or it's in config.h). You might also need to increase your semaphore limits (that's a kernel option). > -----Original Message----- > From: Yin-So Chen [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, August 08, 1999 12:11 AM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Backend cache problem revisited > > Hi, > > after reading through the archives it seems that this particular error > > NOTICE: SIAssignBackendId: discarding tag 2147483553 > Connection to database failed > FATAL 1: Backend cache invalidation initialization failed > > had not come up for a while for most people. However I didn't see any > postings about a solution either, so I tried to figure out if this > problem went away after the 6.3.2 build. On 6.3.2 this error occurs > after there are more than 32 concurrent connections. On 6.4.2 the > number of concurrent connections allowed doubled to 64, but it occurs > again if you create more. My system environment has dual PII450, 1GB > RAM, and I am running RedHat5.2 with Apache1.3.6 & mod_perl & > Postgresql6.3.2 (all RedHat builds except for the kernel). I use > mod_perl to keep the database connection persistent. With 1GB of ram I > can hold at least 100 connections open at the same time, and I would > really like to be able to utilize my computer's resources fully. > > Can anyone tell me how to reconfigure postgresql so I can avoid this > error when opening more connections? Any help is greatly appreciated. > > Regards, > > Yin-So Chen
