| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | Mike Diehl <jdiehl(at)sandia(dot)gov>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Ran out of connections |
| Date: | 2002-12-04 23:23:21 |
| Message-ID: | 1039044201.8617.241.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Once your done scoping other things out, you might also want to look at
increasing the number of allowed connections (in postgresql.conf). The
defaults can be low for high traffic systems.
Robert Treat
On Wed, 2002-12-04 at 17:29, Steve Crawford wrote:
> You probably didn't need to reboot - I suspect you could have probably
> restarted PostgreSQL and Apache (quick version) or killed the extra postgres
> processes.
>
<snip lots of good suggestions>
>
> Cheers,
> Steve
>
>
> On Wednesday 04 December 2002 2:08 pm, Mike Diehl wrote:
> > Hi all.
> >
> > Twice this week, I've come to work to find my Postgres server out of
> > connections... effectively freezing my web server.
> >
<snip>
> >
> > Can anyone tell me how to fix this? The out put of the ps command can be
> > seen at http://dominion.dyndns.org/~mdiehl/ps.txt
> >
> > Thanx in advance,
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Diehl | 2002-12-04 23:52:58 | Re: Ran out of connections |
| Previous Message | Steve Crawford | 2002-12-04 22:29:25 | Re: Ran out of connections |