Search Postgresql Archives

Re: Restoring a database problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Sep 30, 2020, at 6:11 PM, Bruce Momjian <bruce@xxxxxxxxxx> 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.

--
 Bruce Momjian  <bruce@xxxxxxxxxx>        https://momjian.us
 EnterpriseDB                             https://enterprisedb.com

 The usefulness of a cup is in its emptiness, Bruce Lee

https://www.google.com/url?sa=t&source=web&cd=&ved=2ahUKEwiB56D1k5LsAhXBAp0JHQkYA3MQFjAAegQIBxAB&url="">




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux