Hey all! Quick question about tap-postgres. I’m running into the following error:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: FATAL:  sorry, too many clients already cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres

upon trying to flow a bunch of Slack message data into a postgres database. I’ve found a corresponding GitHub issue, and was wondering how to proceed from here. Is there any way I could use specify to meltano to use a particular git commit version of tap-postgres, since there hasn’t been a new release since the fix? Or is there some other way in which I should proceed? Thanks for the help! (and thanks everyone for all their work on these awesome projects!)

Yes you can pin to a version. Check out https://docs.meltano.com/guide/plugin-management#pinning-a-plugin-to-a-specific-version

Missed that in the docs, thank you very much!