On Fri, Dec 20, 2024 at 2:25 PM Y_Bharani_mbsv <mail...@yahoo.com> wrote:
> Team > I have the need to have postgresql db running in multiuser mode and do my > needed tasks for few mins. > > How to restrict all the application layer , not to get connected with the > postgres db , > during my specific time window > 1. Create a pg_hba_maintmode.conf with only the relevant hosts in it. 2. Copy pg_hba.conf to pg_hba_multi.conf. 3. Copy pg_hba_maintmode.conf to pg_hba.conf. 4. pg_ctl reload. 5. Use pg_stat_activity and pg_cancel_backend() to kill the application connections. 6. Do your work. 7. Copy pg_hba_multi.conf to pg_hba.conf. 8. pg_ctl reload Or... just shut down the user application. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
