[Haskell-cafe] Yesod app uses wrong port when connecting to PostgreSQL

[Viktor Dukhovni]

> On Mar 6, 2017, at 2:55 PM, Geraldus <heraldhoi at gmail.com> wrote:
> 
> Hi folks!
> 
> I'm struggling with following error:
> 
> libpq: failed (could not connect to server: Connection refused
>         Is the server running on host "localhost" (127.0.0.1) and accepting
>         TCP/IP connections on port 5432?
> 
> I see such messages in Keter's log (in app folder). The VPS where the app deployed running PostgreSQL 9.6 on port 5433. I have changed default port in:
> 
> 	• config/settings
> 	• config/keter.yaml
> 	• /opt/keter/etc/postgres.yaml on server side
> None of these steps helped. I wasn't able to find other port configuration places. What else can I do?

On my system:

$ grep '543[23]' /etc/services 
postgresql      5432/tcp   #PostgreSQL Database
postgresql      5432/udp   #PostgreSQL Database

-- 
	Viktor.