2018/01/14: Difference between revisions
< 2018
No edit summary |
rearranged order slightly |
||
| Line 1: | Line 1: | ||
==2018-01-14== | ==2018-01-14== | ||
My current plan is: | My current plan is: | ||
# create new system user "tootcat" | |||
# create a new Postgres db for toot.cat's Mastodon | # create a new Postgres db for toot.cat's Mastodon | ||
# migrate the data there | # migrate the data there | ||
# install Mastodon under user "tootcat" | |||
# install Mastodon under "tootcat" | |||
# run Mastodon's schema upgrade rake task | # run Mastodon's schema upgrade rake task | ||
# test the result as https://new.toot.cat (get it working) | # test the result as https://new.toot.cat (get it working) | ||
| Line 11: | Line 11: | ||
## run the migration script | ## run the migration script | ||
## reconfigure nginx to point to the new instance | ## reconfigure nginx to point to the new instance | ||
====revisions==== | |||
* Decided it would simplify things if I went ahead and created the "tootcat" system user first. | |||
===Notes=== | ===Notes=== | ||
Inside /root/backups: | Inside /root/backups: | ||
Revision as of 17:54, 14 January 2018
2018-01-14
My current plan is:
- create new system user "tootcat"
- create a new Postgres db for toot.cat's Mastodon
- migrate the data there
- install Mastodon under user "tootcat"
- run Mastodon's schema upgrade rake task
- test the result as https://new.toot.cat (get it working)
- write a script to automate the data migration
- in close succession:
- run the migration script
- reconfigure nginx to point to the new instance
revisions
- Decided it would simplify things if I went ahead and created the "tootcat" system user first.
Notes
Inside /root/backups:
su - postgres -c 'pg_dump mastodon' > tootcat.sql
Upgrading Mastodon: official
I'm calling the new db tootcat-masto-r1 (toot.cat Mastodon db revision 1) (possibly with '-' replaced by '_').
Probably just need to do this next: CREATE DATABASE tootcat-masto-r1;
...or, rather: createdb --owner=tootcat tootcat-masto-r1 -- except do I need to create "tootcat" as a system user first? Or a db user?