Forum .LRN Q&A: Re: How come my Postgres server processes are multiplying like rabbits on Easter?

Collapse
2: Re: How come my Postgres server processes are multiplying like rabbits on Easter? (response to 1)
Posted by Patrick Giagnocavo on 04/10/04 11:39 PM
Bruce,  A lot of database queries get executed when you start a dotLRN or OpenACS instance.  I would say it is usual that at least 3 db connections get started at a minimum.

If you look at your nsd.tcl file, you will see 3 separate db pools.  Each one of them is used right away, so there needs to be at least one connection made for each pool.

If Postgres is "giving up" well, I don't know what you mean by that.  Perhaps you need to add more swap to your system, or maybe you should change the limit on the number of PG processes in your postgresql.conf file.