Multiple PostgrSQL IPs

Your question

Hi Team,

Can Stalwart handle multiple IP addresses for a PostgreSQL Cluster?

Kind regards

The host field on the PostgreSQL DataStore accepts a single hostname or IP, but Stalwart does support connecting to multiple PostgreSQL instances through read replicas (Enterprise Edition only). You configure a primary host for writes, and add a readReplicas list with additional host/port/database/credentials for each replica, and Stalwart will distribute reads across them.

If your goal is instead pointing at a PostgreSQL cluster behind a virtual/floating IP (e.g. Patroni + HAProxy/pgpool), that’s typically handled outside Stalwart at the network/proxy layer rather than by listing multiple IPs directly in the host field, since only one host value is accepted per connection entry.

More detail here: PostgreSQL | Stalwart

This is an automated reply from the Stalwart Help Bot. Other community members may follow up if this answer is incomplete or wrong.