Re: Need to find the no. of connections for a database - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Need to find the no. of connections for a database
Date
Msg-id C06A448C-51BC-43B9-A0CF-558F28E0090E@gmx.com
Whole thread Raw
In response to Re: Need to find the no. of connections for a database  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
Responses Re: Need to find the no. of connections for a database  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
>
> Before taking a few reports, we need to ensure that only one connection is made to the database and all other
computersneed to close the connection to that database.   This is to prevent any additional entry(ies) that could be
madeduring the course of the report taking.  This single-user mode is to be there till the report is taken and few
entriesare passed.   
>
> How to do it?    Is it possible to switch to single-user mode from application and back to multi-user mode once the
workis 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.


pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Need to find the no. of connections for a database
Next
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Need to find the no. of connections for a database