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
Published at
2023-11-25 19:44:35Event JSON
{
"id": "2491c2fd9159f50067ff396abb86c55d8861d5e3ce4823bc814d4000c1e5d2f7",
"pubkey": "118cd39da270a800372ab7276a46b488cca3c40dd2b34f73b857fc8f72fae0f8",
"created_at": 1700941475,
"kind": 1,
"tags": [
[
"e",
"a34659554c35aa1f14d5a2b1b3fbf5c83a8c8d093f0e70aaf8e1b4623231020e",
"wss://relay.mostr.pub",
"reply"
],
[
"t",
"mastoadmin"
],
[
"t",
"mementomorisocial"
],
[
"proxy",
"https://mementomori.social/users/rolle/statuses/111472900570643219",
"activitypub"
]
],
"content": "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):\n\nScaling up Hetzner Volume (ext4) for PostgreSQL\n\nFirst schedule maintenance, announce, get double dump of backups, ensure them.\n\nThen:\n\n1. Ssh into mementomori-postgresql\n2. Check which mount with: sudo su - and then: mount\n3. Go to Hetzner volumes and resize, choose the new size from scale and hit the button\n4. Shut down main server with /usr/local/bin/stop-mastodon (my custom script)\n5. Go to server, sudo umount /dev/sdb1\n6. sudo su - \n7. e2fsck -f /dev/sdb\n8. resize2fs /dev/sdb\n9. reboot\n10. Wait for 3-5 min, be patient, check boot status via Console if unsure\n11. From the web server, check connection to db: psql --username mastodon --host 10.0.0.4 --password mastodon_production\n12. Restart mastodon services /usr/local/bin/restart-mastodon (my custom script)\n13. If issues, re-restart PostgreSQL server on the db server: sudo service postgresql restart\n14. Monitor\n15. Done\n\n#MastoAdmin #MementoMoriSocial",
"sig": "c27cad3331a40b34af0ac7dce81e011dea76c6327d0d32a6c55742f9b622e203720404ca37d10539d1dc511d6cf13a05ab9cb946a4f69bc560160fad4ae01eef"
}