Connecting to a postgres database does not work as indicated in the suggestion

When defining a new database which has to connect to an existing Postgres, you have to fill in an URL. Just above it, it suggest a format reading “host=$host:port dbname=mydb”.
When I follow that and fill in host=:5432 dbname=, the connection does not work.
When I do “host= dbname=” then it works OK.
Googling I found suggestion that if the port needs to be given, the following should work
host= port=5432 dbname=.
Is this a known issue???

There is written host=$host:port dbname=mydb. host=:5432 couldn’t work, because there doesn’t appear any host. It must be something like host=localhost:5432 or host=192.168.0.1:5432 or host=www.example.com:5432.

2 Likes

Sorry, my fault , typo. The connection string I tried was indeed host=localhost:5432. I tried the IP address and the FQDN as well with the same result.