kapa.ai
05/29/2024, 1:09 PMbash docker exec -ti airbyte-db psql -U docker -d airbyte
You can then use standard Postgres backup commands to create a backup of the database. 2. Update Airbyte: Proceed with updating Airbyte to the new version. Ensure that the Docker volumes are not removed during this process, as they contain the database data. 3. Verify the State: After the update, you can verify that the state has been restored by querying the state table in the internal database: bash SELECT * FROM state;
For more detailed information on how Airbyte persists state and how to access the internal database, 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 any issues with the state after the update, you may need to troubleshoot based on the specific error messages or symptoms you observe. In some cases, reviewing the [schema change management documentation](https://docs.airbyte.com/using-airbyte/schema-change-management#resolving-breaking-changes) may also be helpful if the update involves breaking changes.