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:ychen1@uswest.net]
> Sent: Sunday, August 08, 1999 12:11 AM
> To: pgsql-general@postgreSQL.org
> 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