pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres: MS Access and Tomcat
2+ messages / 2 participants
[nested] [flat]
* Postgres: MS Access and Tomcat
@ 2003-11-26 16:20 mohan@physics.gmu.edu
0 siblings, 1 reply; 2+ messages in thread
From: mohan@physics.gmu.edu @ 2003-11-26 16:20 UTC (permalink / raw)
To: pgsql-sql
Hi All
I am using postgres database. Users of the DB include Web users thro tomcat
and internal user thr'o MS Access. The problem is the users of Access
sometimes do not close these connections and postgres fails saying too
many connections for the web users. Is there a way i can resolve this by
uncommenting the #Max_connections=32 in the postgresql.conf. What are the
effects of uncommenting this part in postgresql.conf. Do i need to make
any more changes when uncomment the Max_connections=32 in the
postgresql.conf file
Thank you very much
--Mohan
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres: MS Access and Tomcat
@ 2003-11-26 17:27 Richard Huxton <dev@archonet.com>
parent: mohan@physics.gmu.edu
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2003-11-26 17:27 UTC (permalink / raw)
To: pgsql-sql
On Wednesday 26 November 2003 16:20, mohan@physics.gmu.edu wrote:
> Hi All
> I am using postgres database. Users of the DB include Web users thro tomcat
> and internal user thr'o MS Access. The problem is the users of Access
> sometimes do not close these connections and postgres fails saying too
> many connections for the web users. Is there a way i can resolve this by
> uncommenting the #Max_connections=32 in the postgresql.conf. What are the
> effects of uncommenting this part in postgresql.conf. Do i need to make
> any more changes when uncomment the Max_connections=32 in the
> postgresql.conf file
You can set max_connections higher, and unless your shared-buffer settings are
very low that should be fine.
Where you may encounter problems is if the Access users have open transactions
which can end up blocking other clients. I seem to recall a timeout option in
the ODBC manager that should disconnect them after a certain time.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-11-26 17:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-26 16:20 Postgres: MS Access and Tomcat mohan@physics.gmu.edu
2003-11-26 17:27 ` Richard Huxton <dev@archonet.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