eupolicy.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
This Mastodon server is a friendly and respectful discussion space for people working in areas related to EU policy. When you request to create an account, please tell us something about you.

Server stats:

201
active users

#upgrading

0 posts0 participants0 posts today
Continued thread

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

Once you have installed #OpenBSD, updates and upgrades mainly involve running

$ doas syspatch

and

$ doas pkg_add -u

to update any packages.

$ doas sysupgrade

for the next release.

Some background on how things work:

Keeping Your OpenBSD System In Trim: A Works For Me Guide nxdomain.no/~peter/keeping_you (also prettified and G-tracked as bsdly.blogspot.com/2012/07/kee)
You've Installed It. Now What? Packages! nxdomain.no/~peter/youve_insta (prettified, G-tracked bsdly.blogspot.com/2013/04/you)
#sysadmin #upgrading

nxdomain.noKeeping Your OpenBSD System In Trim: A Works For Me Guide