State Backend - External Postgres Hi all, I'm usin...
# troubleshooting
j
State Backend - External Postgres Hi all, I'm using the docker version of Meltano 2.17.0 I've been playing with the state and trying to set this up on an external postgres db, using the commands below:
docker run  -v $(pwd):/project -w /project meltano/meltano config meltano set state_backend.uri <postgresql://user:pass@server12345.aws.com:5432/dbtest?options=-csearch_path%3Dmelty>
docker run  -v $(pwd):/project -w /project meltano/meltano config meltano set database_uri <postgresql://user:pass@server12345.aws.com:5432/dbtest?options=-csearch_path%3Dmelty>
I did this in a previous version and could make it work. Now when i try to run the pipeline i'm getting the following error message:
Cannot start plugin tap-mysql: 'postgresql' is not a valid StateBackend
Any idea of what could be the issue here?
Ok, the funny thing is that it is writing these error messages in postgres, in the runs table, meaning that the
database_uri
parameter seems to be ok, but the
state_backend.uri
it's not.
I made it work by setting the
database_uri
with the postgres connection and
state_backend.uri to 'systemdb'