Martin serving multiple database connections

[darrenpierre90]

Hi, I'm attempting to use Martin to serve from multiple Postgres databases. To do that I'm trying to setup Martin config where we can set up various 2 but potentially more Postgres databases

what have I tried so far?

I've tried adding two connection strings and it seems the second connection string overwrites the first one.

I've put a connection string in an array, but that also doesn't work.

in the Martin docs , it says

Database configuration. This can also be a list of PG configs.

But confused about how to set it up .

Any Help would be appreciative.

[CommanderStorm]

This might be badly documented or we might have a bug.

We mean this like here:

martin/martin/src/pg/config.rs

Lines 196 to 198 in 2d3e4d0

	postgres:
	- connection_string: 'postgres://postgres@localhost:5432/db'
	- connection_string: 'postgresql://postgres@localhost:5433/db'

=> a list of postgres-configurations, not a list of connection_strings

Could you recheck if you have 2 configs?

If the issue is what I think it is, how would you have understood the docs how We meant it:
Would the following be better

# Database configuration.
# 
# This can also be a list of postgres configurations (i.e. a list of the dicutionary shown below)

[darrenpierre90]

I've also tried that variant and I got the following error :

[darrenpierre90]

I think if there was just an example shown , it would make the documentation better

[nyurik]

this is not valid yaml.

listen_addresses: '0.0.0.0:3000'
postgres:
  - connection_string: 'postgresql://server1'
    default_srid: 4326
    auto_bounds: skip
  - connection_string: 'postgresql://server2'
    default_srid: 4326
    auto_bounds: skip

[nyurik]

Any documentation improvement PRs are welcome ;)

[darrenpierre90]

Great thanks it works now thank you @nyurik @CommanderStorm