Re: Redundant Database, Pgsql ?

2023-02-19 Thread Benny Pedersen
Paul Kudla skrev den 2023-02-19 16:01: May I please get some guidance on what to add to talk to another postgresql server (i have 6 replicated servers so would probably want a couple worst case issue) change host=localhost to host=some-other-hostname-with-multiple-ips :) then dovecot with time

Re: Redundant Database, Pgsql ?

2023-02-19 Thread David White
It sounds like you want your application (Dovecot) to gracefully failover. Take a look at https://www.citusdata.com/blog/2021/02/12/reconnecting-your-app-after-a-postgres-failover/. Perhaps that's what you're looking for, namely, the section on "Multi-Hosts Connection Strings, thanks to libpq"

Re: Get correct subjects in summary but wrong article body after transitioning between servers

2023-02-19 Thread Steinar Bang
> Steinar Bang : > Steinar Bang : >> I am transitioning between servers (both debian 11.6 with dovecot >> 2.3.13) and I'm seeing some strange behaviour after the transition: it >> seems like dovecot is listing the correct subject for the test messages >> I'm sending in what's shown in my M

Redundant Database, Pgsql ?

2023-02-19 Thread Paul Kudla
I am aware that there are provising for redundant database connections Basically i was working on my main db server (which is also a mail sever) I current have this in the dovecot-pgsql.conf __ driver = pgsql connect = host=l