Hi all. I'm running into a problem with PostgreSQL in that it's reaching the max. number of connections it allows.
I know the easy way out of this is to up the number of connections, but I'm thinking it might be something in my code as well.
I use ADOdb for all my db stuff, so I thought it might be that since I'm not closing my the connection object after I create a new instance of the ADOdb class, they were being left open and that is why I got the error.
However, I found the following in their docs:
"PHP4 proudly states that we no longer have to clean up at the end of the connection because the reference counting mechanism of PHP4 will automatically clean up for us."
So from this it seems that this should not be the problem.
Any ideas as to why connections would remain active after a script has executed?
I'm the only person working on this server (with PHP and PostgreSQL at least) so it's rather surprising.
Thanks in advance,
Pablo
