Difference between revisions of "2018/01/14"

Revision as of 17:18, 14 January 2018

My current plan is:

create a new Postgres db for toot.cat's Mastodon
migrate the data there
create new user "tootcat"
install Mastodon under "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:
1. run the migration script
2. reconfigure nginx to point to the new instance

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?

Revision as of 14:32, 14 January 2018 (view source) Woozle (talk \| contribs) (saving work) ← Older edit		Revision as of 17:18, 14 January 2018 (view source) Woozle (talk \| contribs) Newer edit →
Line 20:		Line 20:

	Probably just need to do this next: <code>CREATE DATABASE tootcat-masto-r1;</code>		Probably just need to do this next: <code>CREATE DATABASE tootcat-masto-r1;</code>
		+
		+	...or, rather: <code>createdb --owner=tootcat tootcat-masto-r1</code> -- except do I need to create "tootcat" as a system user first? Or a db user?