Re: use superuser connection from php

> we have a php application which gets from time to time database errors

> which look like there are not enough connections (we have 100
> connections allowed to postgresql) -
>
> i read that there are two db connections reserved for su. is there a
way
> to use them from php in order to check if the database is really out
of
> connections (with - 'SELECT count(*) FROM pg_stat_activity') or the
> problem is different?

You can connect as superuser on a different connection and issue that
SELECT statement.

But I wouldn't do that. What if there is a problem and all availaible
superuser connections are exhausted? You would not be able to connect
to the database any more, even as superuser.

I would rather examine the SQLSTATE you get from the failed connection
attempt. PostgreSQL returns SQLSTATE 53300 (TOO MANY CONNECTIONS) when
the
maximum os reached. This way you can distinguish that case from others.

Yours,
Laurenz Albe