Not sure if this is a bug or not, but running into an issue when using

inherit_from

with the

target-postgres

plugin. If I run

target-postgres

directly with the env variable, it works:

loaders:
      - name: target-postgres
        config:
          host: ${DB_HOST}
          port: ${DB_PORT}
          user: ${DB_USER}
          password: ${DB_PASSWORD}
          database: ${DB_DATABASE}
          default_target_schema: ${DB_SCHEMA}

However, if I try and run the extension, it complains about an invalid string literal for

PORT

, so I have to hard code the port. It's only the port that is not being pulled in correctly, which is also odd.

- name: target-postgres--extension
    inherit_from: target-postgres
    config:
      activate_version: false
      add_record_metadata: false

Not the end of the world, but I did find it strange.

That's a bug! https://github.com/meltano/meltano/issues/9299

Thanks, Edgar!