Re: Need to find the no. of connections for a database

Поиск
Список
Период
Сортировка
От sivapostgres@yahoo.com
Тема Re: Need to find the no. of connections for a database
Дата
Msg-id 1393516227.2562442.1582789296867@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Need to find the no. of connections for a database
Re: Need to find the no. of connections for a database
Список pgsql-general
Hello,

Before taking a few reports, we need to ensure that only one connection is made to the database and all other computers need to close the connection to that database.   This is to prevent any additional entry(ies) that could be made during the course of the report taking.  This single-user mode is to be there till the report is taken and few entries are passed.  

How to do it?    Is it possible to switch to single-user mode from application and back to multi-user mode once the work is completed?  Or any other solution available?

Happiness Always
BKR Sivaprakash


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: information_schema performance in Postgres 12
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: How to install check_postgres on CentOS 8?