pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgres: MS Access and Tomcat
2+ messages / 2 participants
[nested] [flat]

* Postgres: MS Access and Tomcat
@ 2003-11-26 16:20 mohan@physics.gmu.edu
  2003-11-26 17:27 ` Re: Postgres: MS Access and Tomcat Richard Huxton <dev@archonet.com>
  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 16:20 Postgres: MS Access and Tomcat mohan@physics.gmu.edu
@ 2003-11-26 17:27 ` Richard Huxton <dev@archonet.com>
  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