is it possible to use same meltano tap for different sourcers?

yes, it uses inheritance [which IMO makes this feature difficult to discover], example:

plugins:
  extractors:
  - name: tap-postgres
    variant: meltanolabs
    pip_url: git+<https://github.com/MeltanoLabs/tap-postgres.git>
  - name: tap-postgres--payment-svc-db
    inherit_from: tap-postgres
  - name: tap-postgres--credit-svc-db
    inherit_from: tap-postgres

@Charles Feduke, do i need to set config for base plugin as well ? If don't its complaining that user, host etc is not set for tap-postgres

the only thing I set was the config/database since its shared amongst all of my databases… instead I have a separate config section, where

$VARIABLES

are environment variables:

- name: stg
  config:
    plugins:
      extractors:
      - name: tap-postgres--payment-svc-db
        config:
          host: $PAYMENT_SVC_DB_HOST
          port: 5432
          user: $PAYMENT_SVC_DB_USER
          password: $PAYMENT_SVC_DB_PASSWORD
          filter_schemas:
          - payment