On Sunday, 23 November 2025 at 14:10, John Fawcett via Postfix-users
<[email protected]> wrote:
>
> Hi
>
> my suggestion would be to look at the hosts setting.
>
> You stated above that the hosts setting started with something like this:
>
> hosts=postgresql://
>
> But if you compare that to the error message it is not quite the same thing:
>
> connect to pgsql server postgres://
>
> The postgresql C library has two different functions for connecting to the
> database, one based on the url type syntax and one based on explicit
> parameters. When deciding which function to call, Postfix checks whether the
> hosts parameter starts with postgresql. In your original configuration I
> guess this was the case, but from the error message, I doubt whether that is
> still the case.
>
> If you go back to the postgresql:// syntax hopefully you will solve the
> problem.
>
Interesting spot John !
According to the docs
(https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS)
"The URI scheme designator can be either postgresql:// or postgres://."
But changing Postfix to "postgresql://" did change the nature of my error
message.
I now get "failed: Connection timed out??Is the server running on that host and
accepting TCP/IP connections??"
Which also doesn't make sense. Because it is running, I can connect to it via
psql, using the same url, it logs in instantly.
Only thing I can think of its its a v4 only postgres host whilst the posfix
server is dual-stack. But surely Postfix would fallback promptly to v4 ?
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
