Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
On Sep 30, 2020, at 6:11 PM, Bruce Momjian <bruce@momjian.us> 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 apanic 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 fromconnecting again until the restore has completed.Currently I have been logging into a bunch of servers and stopping variousdaemons, then on the database server killing processes until the database isapparently idle then dropping the database and doing the restore. Thenrestarting the daemons etc. I am sure I am not doing this the right way soadvice gratefully received.I would modify pg_hba.conf to block access temporarily.-- Bruce Momjian <bruce@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
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.
В списке pgsql-general по дате отправления: