## What this teaches
How to error while migrating from Cockroach to Postgres.
## The problem
Issue zitadel/zitadel#9042 (closed, 26 comments): ### Preflight Checklist
- [x] I could not find a solution in the documentation, the existing issues or discussions
- [ ] I have joined the [ZITADEL chat](https://zitadel.com/chat)
### Environment
Self-hosted
### Version
2.65.1
### Database
CockroachDB
### Database Version
23.2.16, migrating to Postgres 16/17
### Describe the problem caused by this bug
There seems to be an issue when migrating from CockroachDB to Postgres on this version.
Following the instruction from here (https://zitadel.com/docs/self-hosting/manage/cli/mirror) to migrate to a blank postgres instance fails...
## What worked (verified answer)
[adsehgal (commenter)]: To migrate a Zitadel instance from CockroachDB to PostgreSQL, run the init command first, then the setup command, then mirror with the --replace flag. Two reporters confirmed the migration worked with no issues.
## Source
gh:zitadel/zitadel#9042 - https://github.com/zitadel/zitadel/issues/9042