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 restore it.
I need to close all existing connections and the prevent people/processes from
connecting again until the restore has completed.
Currently I have been logging into a bunch of servers and stopping various
daemons, then on the database server killing processes until the database is
apparently idle then dropping the database and doing the restore. Then
restarting the daemons etc. I am sure I am not doing this the right way so
advice gratefully received.
I would modify pg_hba.conf to block access temporarily.
As would I; it's the first thing I thought of...
--
Angular momentum makes the world go 'round.
