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 @
[email protected]
