Difference between revisions of "User:Woozle/toot.cat/2018/01/14"
Jump to navigation
Jump to search
(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?