Re: Restoring a database problem

2020-10-03 Thread Glen Eustace
> I need to close all existing connections and the prevent people/processes from > connecting again until the restore has completed. I was hoping there was a command in psql that would do both, that is, kick the exisiting connections and stop new ones.  It was being a bit optimistic I think, but su

Re: Restoring a database problem

2020-10-03 Thread Peter J. Holzer
On 2020-09-30 20:11:12 -0500, Ron wrote: > On 9/30/20 7:11 PM, Bruce Momjian wrote: > > On Thu, Oct 1, 2020 at 01:00:21PM +1300, Glen Eustace wrote: > > > I have had to do this so rarely and it has almost always been in a bit of > > > a > > > panic so may well be missing something really obvious.

Re: Restoring a database problem

2020-09-30 Thread Ron
On 9/30/20 7:11 PM, Bruce Momjian wrote: On Thu, Oct 1, 2020 at 01:00:21PM +1300, Glen Eustace wrote: I have had to do this so rarely and it has almost always been in a bit of a panic so may well be missing something really obvious. What I want to know is how to quiese a database to that I can

Re: Restoring a database problem

2020-09-30 Thread Rob Sargent
> On Sep 30, 2020, at 6:11 PM, Bruce Momjian wrote: > > On Thu, Oct 1, 2020 at 01:00:21PM +1300, Glen Eustace wrote: >> I have had to do this so rarely and it has almost always been in a bit of a >> panic so may well be missing something really obvious. >> >> What I want to know is how to qu

Re: Restoring a database problem

2020-09-30 Thread Bruce Momjian
On Thu, Oct 1, 2020 at 01:00:21PM +1300, Glen Eustace wrote: > I have had to do this so rarely and it has almost always been in a bit of a > panic so may well be missing something really obvious. > > What I want to know is how to quiese a database to that I can restore it. > > I need to close al

Restoring a database problem

2020-09-30 Thread Glen Eustace
I have had to do this so rarely and it has almost always been in a bit of a panic so may well be missing something really obvious. What I want to know is how to quiese a database to that I can restore it. I need to close all existing connections and the prevent people/processes from connecting ag