Mattermost v8.0+ and PostgreSQL
-
@Lanhild said in Mattermost v8.0+ and PostgreSQL:
@cvachery Do you have a list of commands/queries you've done?
I tried both methods, and had issues with them.
The 1st (database migration) renders in a plethora of errors with indexes and columns. Even though I followed Cloudron docs and the upstream's, I can't seem to be able to make it work.
The 2nd (Bulk import) didn't restore any of my DMs which makes it a no-go.
If you could provide some guidance, I'd be very grateful.
@cvachery If you can get back to me on this, I'd be very happy.
@Lanhild Sorry missed your message.
I will see if I can do another test migration this afternoon (CEST) and take some more notes. But basically I wrote the steps below on a clean Mattermost PostgreSQL install:- Dumped the DB with :
pg_dump -d mattermost > mattermost.dump - Renamed on cloudron
config.jsontoconfig.json.orig - Copied
mattermost.dumpandconfig.jsonto cloudron mattermost via the file manager - Edited
config.jsonwith the value fromconfig.json.orig(to get the PostgreSQL details)- "ServiceSettings" => "SiteURL"
- "SqlSettings" => "DataSource" and "DataSourceReplicas"
- "FileSettings" => "Directory"
- From the terminal app did
PASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} pg_restore -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE} ../data/mattermost.dump
- Rsynced all my attachments from origin_server to cloudron_server:app_folder (cf girish post )
- Restarted the app
- Dumped the DB with :
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login