Search Postgresql Archives

Re: use superuser connection from php

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Albe Laurenz wrote:
> You can connect as superuser on a different connection and issue that
> SELECT statement.

OK

> 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.

True.

> 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.

Oh, thanks a lot for the hint!

Iv



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux