Обсуждение: to many connection
hi I have a problem with my postgre 1 time a day my postgre crash my server and send me a message "... to many clients connect..." I have incrase the sharedbuffer and the max connection in postgre.conf but I not solve the problem . can yaou help me? tank by coke
Hi everybody, I'm using PostgreSQL unixODBC with Macromedia ColdFusion 5. With newer unixodbc driver I can't select text longer than 8K. I'm not a C programmer, but the source code, defines TEXT_FIELD_SIZE 8190 and mallocs up to this 8190 +5, even if now postgres supports dynamically growing text fields. I noticed another wrong behaviour. The driver does't escape special chars correctly. The following combination produce an error: \' I would like to know if the odbc driver included in PG 7.1.3 is affected from the same "bug" and if there are substantial differents Thanks in advance. -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available --------------------------------------------------
Hi- It sounds like you have done the right thing with the postgresql.conf file. Perhaps the changes in postgresql.conf are not getting picked up. Where is the file located? It should be located in the data directory specified when you did your initdb. Some installations (such as Debian) locate the conf file elsewhere, but then have a link from the data directory. Maybe the links are missing if this is the case. -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of programmers > Sent: Monday, November 12, 2001 4:10 AM > To: Pgsql-Admin > Subject: [ADMIN] to many connection > > > hi > I have a problem with my postgre > 1 time a day my postgre crash my server and send me a message "... to many > clients connect..." > I have incrase the sharedbuffer and the max connection in > postgre.conf but > I not solve the problem . > can yaou help me? > tank > by coke > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >