What is the correct URI syntax for using Forena to connect to a Postgres database? I am trying out Forena Reports and in connecting to a Postgres table I set the the Driver Type to Postgres Database and the URI to postgresql://username:password@127.0.0.1:5432/database.

The problem is when try to connect to the database username and password are correctly sent as the database log produces this message.

 FATAL:  database "database password=password" does not exist


I have created a temporary workaround by creating a user with the same name as the target database, by using the URI and omitting database at the end, as in

postgresql://database:password@127.0.0.1:5432/


What is the correct syntax for this URI postgresql://username:password@127.0.0.1:5432/database which allows a user without the same name as the database?
This worked for me:

host='somesite.comOR_IP' dbname='YourDBName' user='DBUsername'