Re: How to detach a database

2021-08-19 Thread Tom Lane
"David G. Johnston" writes: > On Thursday, August 19, 2021, sivapostg...@yahoo.com > wrote: >> Is there any way to make a PG database either in-active or switch to >> single-user mode ? We want to avoid DELETE database process. > Probably can do it via changing the pg_hba.conf file. Either tha

Re: How to detach a database

2021-08-19 Thread David G. Johnston
On Thursday, August 19, 2021, sivapostg...@yahoo.com wrote: > > Is there any way to make a PG database either in-active or switch to > single-user mode ? We want to avoid DELETE database process. > Probably can do it via changing the pg_hba.conf file. David J.

Re: How to detach a database

2021-08-19 Thread sivapostg...@yahoo.com
Hello, We want to carry out some data manipulation work in a database exclusively.    We don't want any one to connect this database during that time.   How to do it ? In SQL Server there are two ways [ earlier we used SQL Server and now switched to PG ]1.  Change the database to work in single-u