Hi there,
I have problems connecting to a postgres-db that is not on localhost because in this case I need to provide a password.
Looking in the documentation the postgres-database.address should look like: “username:password@host:port/DB” but as soon as I use a password an error occurs saying that ‘username’-DB is unknown!?
Connecting with such an string to the DB works as intended using ‘psql’.
At the moment I ended up trusting any ip-address in postgres…
Postgres requires that you create a database matching the name of any user logging in.
To be clear this can usually be skipped if also specifying a database to connect to, but the Nakama migrate command skips that step in order to first inspect its own database schema.
That is NOT a postgres requirement at all. Has never been.