HowTo Provide Multiple PG Connections in Config

[veschberwilli]

HowTo Provide Multiple PG Connections in Config

[sharkAndshark]

Hi @veschberwilli

keep_alive: 75

listen_addresses: '0.0.0.0:3000'

worker_processes: 8

cache_size_mb: 8
# Database configuration. This can also be a list of PG configs.
postgres:
  - connection_string:  postgres://postgres:postgres@localhost:5411/db
    default_srid: 4326
  - connection_string:  postgres://postgres:postgres@localhost:5422/db
    default_srid: 4326

[nyurik]

@veschberwilli there are two answers to your question:

• if you have different data in two different databases, martin can publish them as two separate sources, just like @sharkAndshark showed above (thx!)
• if you have identical data in two different databases, i.e. mirrors / replicas, and simply want to speed up tile serving because of performance or stability concerns, then no, martin does not support load balancing between multiple databases. You can still get the same result if you configure one of the standard high availability load balancers, and point Martin to it instead of going directly to the database. A quick googling gave me this blog post that mentions multiple load balancers.

[sharkAndshark]

@veschberwilli there are two answers to your question:

• if you have different data in two different databases, martin can publish them as two separate sources, just like @sharkAndshark showed above (thx!)

• if you have identical data in two different databases, i.e. mirrors / replicas, and simply want to speed up tile serving because of performance or stability concerns, then no, martin does not support load balancing between multiple databases. You can still get the same result if you configure one of the standard high availability load balancers, and point Martin to it instead of going directly to the database. A quick googling gave me this blog post that mentions multiple load balancers.

Maybe we could document this under the 3.1 PostgreSQL Connection though user could find a clue in the description about configuration file.

[nyurik]

Sure, would be great, thanks!

[veschberwilli]

Hey @sharkAndshark and @nyurik ,
thanks a lot for the quick response and for proviing the code snippet for the config.

Helps a lot!