I remember that you cannot open more than 16 sessiones at same time
by default, if more than that you have to reset, I believe you can
find how from documentation.
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
On Mon, 11 Dec 2000, Dronamraju Rajesh wrote:
> thanks tom....But strange thing is that my database
> has only 15 tables totally...which are very small
> so how would be the way of me reaching to 1000
> and why do i get an error message "sorry too many
> clients" ???
> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Dronamraju Rajesh <drajesh80(at)yahoo(dot)com> writes:
> > > database:- Postgres 6.5.2 ( pl dont suggest to
> > upgrade
> > > to 7.0.2. once this problem is solved. then i can
> > do
> > > testing of my app with postgres 7.0.2)
> > If you update to 7.0.3, you'll probably find this
> > problem
> > goes away. It sounds to me like you are running
> > into a bogus
> > debug check in the older code that assumed
> > LockRelease should
> > never need to release more than a thousand locks.
> > If you don't want to update, try not touching 1000
> > tables in
> > the same transaction. I'm guessing you do a lot of
> > large-object
> > slinging ... otherwise it's not that easy to get to
> > 1000 ...
> > regards, tom lane
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
In response to
pgsql-admin by date
|Next:||From: Adam Lang||Date: 2000-12-12 18:24:16|
|Subject: Re: v7.1 RPMs|
|Previous:||From: Stephan Szabo||Date: 2000-12-12 17:56:49|
|Subject: Re: Foriegn key constraint|
pgsql-bugs by date
|Next:||From: Stephan Szabo||Date: 2000-12-12 18:20:53|
|Subject: Re: constrains of array|
|Previous:||From: Bruce Momjian||Date: 2000-12-12 16:22:29|
|Subject: Re: select cash_out('2'); crashes backend on 7.0.2|