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 :
