<div dir="auto"><span style="font-family:sans-serif;font-size:15.744px">Hi,</span><div dir="auto" style="font-family:sans-serif;font-size:15.744px"><br></div><div dir="auto" style="font-family:sans-serif;font-size:15.744px">It may help to know that libpq also looks to environment variables to get its config: <a href="https://www.postgresql.org/docs/9.3/static/libpq-envars.html" style="text-decoration:none;color:rgb(66,133,244)">https://www.<wbr>postgresql.org/docs/9.3/<wbr>static/libpq-envars.html</a></div><div dir="auto" style="font-family:sans-serif;font-size:15.744px"><br></div><div dir="auto" style="font-family:sans-serif;font-size:15.744px">Cheers,</div><div dir="auto" style="font-family:sans-serif;font-size:15.744px"><br></div><div dir="auto" style="font-family:sans-serif;font-size:15.744px">David</div><div dir="auto" style="font-family:sans-serif;font-size:15.744px"><br></div><div dir="auto" style="font-family:sans-serif;font-size:15.744px">(Apologies for the double mail, I failed to CC the list in the first time)</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 6 Mar 2017 19:55, "Geraldus" <<a href="mailto:heraldhoi@gmail.com">heraldhoi@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><p style="box-sizing:border-box;margin-bottom:16px;color:rgb(36,41,46);font-family:-apple-system,blinkmacsystemfont,"segoe ui",helvetica,arial,sans-serif,"apple color emoji","segoe ui emoji","segoe ui symbol";font-size:14px;margin-top:0px">Hi folks!</p><p style="box-sizing:border-box;margin-top:0px;margin-bottom:16px;color:rgb(36,41,46);font-family:-apple-system,blinkmacsystemfont,"segoe ui",helvetica,arial,sans-serif,"apple color emoji","segoe ui emoji","segoe ui symbol";font-size:14px">I'm struggling with following error:</p><pre style="box-sizing:border-box;font-family:sfmono-regular,consolas,"liberation mono",menlo,courier,monospace;font-size:11.9px;margin-top:0px;margin-bottom:16px;font-stretch:normal;line-height:1.45;word-wrap:normal;padding:16px;overflow:auto;background-color:rgb(246,248,250);border-radius:3px;color:rgb(36,41,46)"><code style="box-sizing:border-box;font-family:sfmono-regular,consolas,"liberation mono",menlo,courier,monospace;font-size:11.9px;padding:0px;margin:0px;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:transparent;border-radius:3px;word-break:normal;border:0px;display:inline;overflow:visible;line-height:inherit;word-wrap:normal">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?
</code></pre><p style="box-sizing:border-box;margin-top:0px;margin-bottom:16px;color:rgb(36,41,46);font-family:-apple-system,blinkmacsystemfont,"segoe ui",helvetica,arial,sans-serif,"apple color emoji","segoe ui emoji","segoe ui symbol";font-size:14px">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:</p><ul style="box-sizing:border-box;padding-left:2em;margin-top:0px;margin-bottom:16px;color:rgb(36,41,46);font-family:-apple-system,blinkmacsystemfont,"segoe ui",helvetica,arial,sans-serif,"apple color emoji","segoe ui emoji","segoe ui symbol";font-size:14px"><li style="box-sizing:border-box">config/settings</li><li style="box-sizing:border-box;margin-top:0.25em">config/keter.yaml</li><li style="box-sizing:border-box;margin-top:0.25em">/opt/keter/etc/postgres.yaml on server side</li></ul><p style="box-sizing:border-box;margin-top:0px;color:rgb(36,41,46);font-family:-apple-system,blinkmacsystemfont,"segoe ui",helvetica,arial,sans-serif,"apple color emoji","segoe ui emoji","segoe ui symbol";font-size:14px;margin-bottom:0px">None of these steps helped. I wasn't able to find other port configuration places. What else can I do?</p><div><br></div></div>
<br>______________________________<wbr>_________________<br>
Haskell-Cafe mailing list<br>
To (un)subscribe, modify options or view archives go to:<br>
<a href="http://mail.haskell.org/cgi-bin/mailman/listinfo/haskell-cafe" rel="noreferrer" target="_blank">http://mail.haskell.org/cgi-<wbr>bin/mailman/listinfo/haskell-<wbr>cafe</a><br>
Only members subscribed via the mailman list are allowed to post.<br></blockquote></div></div>