[Serusers] PostgreSQL

Greg Fausak greg at august.net
Mon Jul 28 18:49:28 CEST 2003

I had this issue as well.

I reported to the list several months ago.  I thought
I posted the fix as well, perhaps not.

The reason is that SER opens many, many database
connections.  I believe 32 connections are opened.  So
You have to increase the number of database connections you
handle in the postgres configuration, which defaults to 16
I think.

The setting you need to tweak is 
max_connections = 256
in the postgresql.conf file.  The database then needs to be
restarted.   Note that this setting affects others, both directly
to postgres and also the operating system (file descriptors, etc)...


> -----Original Message-----
> From: serusers-bounces at lists.iptel.org 
> [mailto:serusers-bounces at lists.iptel.org] On Behalf Of Takefumi Naito
> Sent: Monday, July 28, 2003 10:25 AM
> To: serusers at lists.iptel.org
> Subject: [Serusers] PostgreSQL
> Thanks a lot for your advise.
> I tried to do  
> 	$psql -h localhost -p 5432 -U seruser -W ser
> Connecting database ser is success.
> But in the log file, these following lines appeared 
> after SER started using /usr/sbin/ser command.
> 	FATAL:	 Non_superuser connection limit exceeded
> 	LOG:	 pq_recvbuf:unexpected EOF on client connection
> Maybe this is the reason database doesn't work, I think.
> It seems SER can't connect to postgres.
> What should I do?
> Another problem: SER processes don't stop using /usr/sbin/ser stop. 
> Many SER processes are surviving.
> Is it strange?
> Most sincerely
>                Takefumi
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers

More information about the sr-users mailing list