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.