pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Sorry too many conecctions 2+ messages / 2 participants [nested] [flat]
* Sorry too many conecctions @ 2004-07-21 15:08 Javier Tesis Tolosa Trabajo <tesispostgres@hotmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Javier Tesis Tolosa Trabajo @ 2004-07-21 15:08 UTC (permalink / raw) To: pgsql-sql hi everybody I speak english a little,Sorry. I have A problem whith de connections from a Aplicatio Java, guive me a Error "Sorry too many clients",I think what is becuase I don't close connecction to the DB postgresql, I do aprox. 1000 conecction into statement "while" What can Do? thakns _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.latam.msn.com/ ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Sorry too many conecctions @ 2004-07-21 19:34 Gregory S. Williamson <gsw@globexplorer.com> 0 siblings, 0 replies; 2+ messages in thread From: Gregory S. Williamson @ 2004-07-21 19:34 UTC (permalink / raw) To: Javier Tesis Tolosa Trabajo <tesispostgres@hotmail.com>; pgsql-sql In the root directory in which postgres stores the data is a file: postgresql.conf Edit the file with a text editor (vi / ed / etc.) and change : max_connections = ### to max_connections = 1000 (or more since other applications or a DBA may need to connect as well) and also change shared_buffers = ### to be at least (max_connections * 2), so change this to at least 2000 for 1000 simulataneous connections. More connections use more shared memory so you want to have some limits to the total number. Save the file changes. Stop and restart the postgres instance (reload doesn't work for these settings). Hope this helps, Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: Javier Tesis Tolosa Trabajo [mailto:tesispostgres@hotmail.com] Sent: Wed 7/21/2004 8:08 AM To: pgsql-sql@postgresql.org Cc: Subject: [SQL] Sorry too many conecctions hi everybody I speak english a little,Sorry. I have A problem whith de connections from a Aplicatio Java, guive me a Error "Sorry too many clients",I think what is becuase I don't close connecction to the DB postgresql, I do aprox. 1000 conecction into statement "while" What can Do? thakns _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.latam.msn.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-07-21 19:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-07-21 15:08 Sorry too many conecctions Javier Tesis Tolosa Trabajo <tesispostgres@hotmail.com> 2004-07-21 19:34 Re: Sorry too many conecctions Gregory S. Williamson <gsw@globexplorer.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox