Migrating to Postgres - What not to do

[sbeaver28]

Writing this to help anyone else struggling with database migration. Documentation is a little thin :)

I guessed that the correct approach was to:

1. Install Postgresql
2. Create a database. I called it "meshcentral"
3. Create a user with a password and all privileges on database meshcentral
4. Plug the database name, username and password into Meshcentral config

This produced many not-too-informative error messages relating to database tables not existing.

I finally determined that this is not the correct approach. Meshcental will create its own database and populate it as needed. The database name should NOT be provided in the config and the username/password should be the system Postgresql user and password.

My config fragment looks like this:

"postgres": { "host":"localhost", "user":"postgres", "port":5432, "password":"wouldntyouliketoknow" }

After removing the "meshcentral" database I had created --dbexport and --dbimport worked as intended and all my data appeared in Postgres.