Re: How to detach a database - Mailing list pgsql-general

From Tom Lane
Subject Re: How to detach a database
Date
Msg-id 1703941.1629383839@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to detach a database  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, August 19, 2021, sivapostgres@yahoo.com <sivapostgres@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 that or revoke public CONNECT privilege on the database.

            regards, tom lane



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to detach a database
Next
From: Rich Shepard
Date:
Subject: Selecting table row with latest date