Heads up #Sharkey #admins when #upgrading...
If you have a lot of #data in your #instance #database, running pnpm run migrate
might fail because one or more of the ALTER TABLE...
statements might actually timeout on your #PostgreSQL server!
To fix this, attach yourself to your sharkey
database and enter the following...
ALTER DATABASE sharkey SET statement_timeout = '10min';
ALTER ROLE sharkey SET statement_timeout = '10min';
...and try the pnpm run migrate
command again.#SharkeyAdmin #InstanceAdmin @sharkey@sharkey.team