👋 Hello, newbie question here: I'm trying to set the backend state to postgresql, by giving the correct URI to

MELTANO_STATE_BACKEND_URI

, but got this error:

Run invocation could not be completed as block failed: Cannot start plugin tap-postgres: 'postgresql' is not a valid StateBackend

. Does this mean that we only support sqlite when the doc said Meltano support system database?

Hey there! I’m thinking we need to do a better job clarifying this in the docs. If you’re looking to update the system database, you’ll want to look at

database_uri

https://docs.meltano.com/reference/settings#database-uri The state backend can be different from that if you want to use remote storage to track the incremental state between job run invocations.

Thanks for the reply, I should have replied to this thread earler. I ended up setting the

database_uri

, but the document talked about some

state_backend.uri

, which does not seem to apply to database. That section was quite confusing.

Yeah it can be definitely be confusing. State backend is just for the incremental state that’s used to keep track of EL workloads between runs. THat’s just a JSON payload and normally that can be stored locally in SQLite, but we’ve made it so you can store it in GCS, Azure, etc. (and Cloud!). The system database backend will keep track of things like run history. Would be good for us to make it clearer cc @Sven Balnojan