Trying to run RiverGIS 3.0 on QGIS 3.4 using pgAdmin4.

Question

Should I be using a different version? I am getting this error in RiverGIS:

"Couldn't connect to river database: bv mp3.5@localhost

Please, check you database connection settings!"

I have a friend who uses pgAdmin4 regularly for work and he said that I have that part setup correctly.

QGIS says that it is reading the database successfully. I tested this using > Data Source Manager > PostgreSQL >Create a New PostGIS Connection> Test Connection

Answer 1

That could happen if you haven't created an authentication configuration for your connection. You could also use  basic authentication method, as described in the docs, but that is not secure - your password would be stored in plain text. See detailed description of QGIS authentication workflows.

I would suggest to create a new authentication configuration:

Specify user name and password for your database:

Set that authentication configuration for your connection:

Hope this helps!

Comments

I'm okay with using a basic configuration. I am just running this from a home office and no one else runs the machine.

QGIS says that it is reading the database successfully. I tested this using > Data Source Manager > PostgreSQL >Create a New PostGIS Connection> Test Connection

But RiverGIS does not appear to be functioning. All of the pulldown menus are greyed out.

---

If you choose Basic authentication, make sure the username and password are stored in the project file.

---

I created a new database in pgadmin4 and used a new authentication configuration. I wasn't able to get it to run using the basic configuration but the new authentication configuration appears to work well!