Page MenuHomeSoftware Heritage
Paste P164

db upgrade modus operandi
ActivePublic

Authored by ardumont on Jun 2 2017, 3:48 PM.
# tldr
schema update | pglogical.replicate_ddl_command
types, functions, index | manual on master and mirrors
# irc extract
```
15:29:59 ardumont | olasd: can you please remember me the new and proper way to upgrade the main db (without breaking the streaming on the mirror)?
15:34:55 olasd | it depends
15:35:35 olasd | table schema updates should be done on the master through pglogical.replicate_ddl_command
15:35:54 olasd | type updates, function updates need to be done manually on both sides
15:36:37 olasd | index updates need to be done manually
15:38:31 olasd | after an upgrade, the storage backend api server can be restarted without interruption with `systemctl reload gunicorn-swh-storage.service`
```