To successfully update Memoria database there should be no requests from Cerebro clients to the database in the process.
You can solve this by using PostgreSQL tools, limiting the range of network addresses that are allowed to connect to the database. To do this, do the following operations.
- Stop the PostgreSQL service (see section “Stopping the PostgreSQL service”).
- Edit the configuration file pg_hba.conf (how to determine its location, see “Database file structure location”). Comment out all the address ranges except localhost (127.0.0.1). It is required for the list to look like this:
Host all all 127.0.0.1/32 ident
#Host all all 0.0.0.0/0 md5
- Restart PostgreSQL (see section “Starting the PostgreSQL service”).
When Memoria database is finished updating, do not forget to rollback PostgreSQL access permissions, for this you should uncomment commented out lines in pg_hba.conf and restart the service.