Roni Laukkarinen on Nostr: My manual process for this for future use (although 1 TB for the database-only should ...

My manual process for this for future use (although 1 TB for the database-only should be enough for the next 28 years with my calculations):

Scaling up Hetzner Volume (ext4) for PostgreSQL

First schedule maintenance, announce, get double dump of backups, ensure them.

Then:

1. Ssh into mementomori-postgresql
2. Check which mount with: sudo su - and then: mount
3. Go to Hetzner volumes and resize, choose the new size from scale and hit the button
4. Shut down main server with /usr/local/bin/stop-mastodon (my custom script)
5. Go to server, sudo umount /dev/sdb1
6. sudo su -
7. e2fsck -f /dev/sdb
8. resize2fs /dev/sdb
9. reboot
10. Wait for 3-5 min, be patient, check boot status via Console if unsure
11. From the web server, check connection to db: psql --username mastodon --host 10.0.0.4 --password mastodon_production
12. Restart mastodon services /usr/local/bin/restart-mastodon (my custom script)
13. If issues, re-restart PostgreSQL server on the db server: sudo service postgresql restart
14. Monitor
15. Done

#MastoAdmin #MementoMoriSocial