hi all, how to separate two passwords for tap-postgres of 2 different environments? For my case, I have config for environment=dev and another config for environment=prod. Both are using tap-postgress but its settings are different including password.

There might be a better option that his but when you set a password its automatically stored in the .env file called something like

TAP_POSTGRES_PASSWORD

, in that case its hard to have 2 values. You could replace that with

POSTGRES_PASSWORD_DEV

(or similar) and use the template feature in your environment section of the yaml like:

config:
      password: ${POSTGRES_PASSWORD_DEV}