Postgres Pro
Downloads
Home   >   mailing lists

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

From Ireneusz Pluta/wp.pl
Subject Re: Need to find the no. of connections for a database
Date
Msg-id 72f62e47-689a-351a-a711-6cfb7312d282@wp.pl
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
List pgsql-general
Tree view 
W dniu 2020-02-27 o 12:35, sivapostgres@yahoo.com pisze:
> I need to prevent other users from entering any transaction till I finish taking reports from my 
> application.  All users will be using the same application, from which this report is supposed to 
> be printed.
>
maybe advisory lock is what you need?

https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS

pgsql-general by date:

Previous
From: Ravi Krishna
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