Re: use superuser connection from php

Поиск
Список
Период
Сортировка
От pobox@verysmall.org
Тема Re: use superuser connection from php
Дата
Msg-id 4613DA71.7080902@verysmall.org
обсуждение исходный текст
Ответ на Re: use superuser connection from php  ("Albe Laurenz" <all@adv.magwien.gv.at>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "pobox@verysmall.org"
Дата:
Сообщение: Re: use superuser connection from php
Следующее
От: Jonathan Vanasco
Дата:
Сообщение: Re: inserting multiple values in version 8.1.5