Correct Structure for Multiple Databases in Martin

[zsoooc]

Hi!

I want to use Martin with two PostgreSQL connection. Is it possible? If yes, how to do this? With one connection string it works, but when I tried to add more connection strings to the config file, I got this error:
"Unable to parse config file config.yaml: postgres: duplicate entry with key "connection_string" at line 93 column 3"

[CommanderStorm]

Our docs could be better what "a list of PG configs" means.

# Database configuration. This can also be a list of PG configs.
postgres:
  - # Database connection string.
    #
    # You can use environment variables too, for example:
    # connection_string: $DATABASE_URL
    # connection_string: ${DATABASE_URL:-postgres://postgres@localhost/db}
    connection_string: 'postgres://postgres@localhost:5432/db'
  - # Database connection string.
    #
    # You can use environment variables too, for example:
    # connection_string: $DATABASE_URL
    # connection_string: ${DATABASE_URL:-postgres://postgres@localhost/db}
    connection_string: 'postgres://postgres@localhost:5433/db'

I also noticed that this is not tested if you want to help out.
Adding a testcase means that we will know if there is a bug affecting this feature, so win-win 😉

[zsoooc]

Hi! Thanks.

It works with the following config file:

listen_addresses: '0.0.0.0:8000'

postgres:
- connection_string: postgres://postgres:[email protected]:5432/db1
  auto_publish: 
    functions:
        source_id_format: '{schema}.{function}'
- connection_string: postgres://postgres:[email protected]:5432/db2
  auto_publish: 
    functions:
        source_id_format: '{schema}.{function}'