Re: REVOKE command not working as expected

Поиск

Список

Период

Сортировка

От	Guillermo Carrasco
Тема	Re: REVOKE command not working as expected
Дата	12 ноября 2013 г. 18:03:09
Msg-id	CAH-nkqk6amrDozECFKo+kakXPocGm512W=-7x013wxf0H-veoQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: REVOKE command not working as expected (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы	Re: REVOKE command not working as expected
Список	pgsql-admin

Дерево обсуждения

Hi,

Thanks for your answer, I know, that's why we have this statement: https://github.com/guillermo-carrasco/scilifelab/blob/master/scripts/dbsync.sh#L20

On Tue, Nov 12, 2013 at 4:01 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

On Tue, Nov 12, 2013 at 7:58 AM, Guillermo Carrasco
<guillermo.carrasco@scilifelab.se> wrote:
> Hi everyone,
>
> The problem is that sometimes (apparently random), even after having invoked
> EVOKE CONNECT ON DATABASE \"$DB\" FROM PUBLIC;, when the scripts starts
> dumping, it fails because it says that there are some active connections.

Revoking connection does not disconnect currently connected clients.

------------------------------------------------------------------------

Guillermo Carrasco Hernández, Computer Scientist

GitHub: https://github.com/guillermo-carrasco

LinkedIn: http://linkd.in/XeFUSB

Personal blog: http://mussolblog.wordpress.com/

------------------------------------------------------------------------

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