# 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`
```