@kapa.ai As airbyte stores the state in the destination if I update the version of airbyte I’m running inside docker will it restore the state of the connections etc?

Yes, Airbyte stores the state of connections in an internal Postgres database, which is part of the

airbyte-db

Docker container. When you update the version of Airbyte you are running inside Docker, the state of the connections should be preserved as long as the

airbyte-db

container is not removed or its data is not cleared. To verify the state of your connections, you can access the internal Postgres database and check the

state

table. Here are the steps to do so: 1. Access the Airbyte Postgres database:

bash     docker exec -ti airbyte-db psql -U docker -d airbyte

2. View the contents of the state table:

sql     SELECT * FROM state;

This command should return a table with the state information for your connections, similar to the example below:

sql                   id                  |            connection_id             |                                                                                                  state                                                                   |          created_at           |          updated_at           | stream_name | namespace |  type   --------------------------------------+--------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+-------------------------------+-------------+-----------+--------  884a10a7-1c58-4456-af44-c617eec0c1fb | 78cb42b9-e857-4f93-b159-e590ec31d287 | {"state": {"cdc": false, "streams": [{"cursor": "2022-09-02T07:55:58.324989", "stream_name": "table_one", "cursor_field": ["updated_at"], "stream_namespace": "public"}]}} | 2022-09-01 16:52:44.619871+00 | 2022-09-02 07:59:27.304753+00 |             |           | LEGACY

For more detailed information, you can refer to the [Airbyte Protocol documentation](https://docs.airbyte.com/understanding-airbyte/airbyte-protocol) and the [tutorial on incremental data synchronization](https://airbyte.com/tutorials/incremental-data-synchronization#step-2). If you encounter issues after upgrading, you may need to check if there were any changes in the state management between versions. In some cases, rolling back to a previous version might be necessary if the new version introduces issues with state management. For further assistance, you can refer to the [Airbyte forum](https://discuss.airbyte.io/t/2643) or the [GitHub discussions](https://github.com/airbytehq/airbyte/discussions/33809) for community support and updates.