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

From: Ravi Krishna <srkrishna(at)gmx(dot)com>
To: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
Cc: Postgresql General Group <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Need to find the no. of connections for a database
Date: 2020-02-27 11:04:18
Message-ID: C06A448C-51BC-43B9-A0CF-558F28E0090E@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

This concept is outdated. You should set your application to correct isolation level to get a consistent state.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sivapostgres@yahoo.com 2020-02-27 11:35:51 Re: Need to find the no. of connections for a database
Previous Message Peter J. Holzer 2020-02-27 10:07:32 Re: Need to find the no. of connections for a database