apolloconfig / apollo

Apollo is a reliable configuration management system suitable for microservice configuration management scenarios.
https://www.apolloconfig.com
Apache License 2.0
28.93k stars 10.19k forks source link

请问有大佬已经在2.2.0版本上,数据源由mysql切换至pg了嘛? #5141

Closed MyGit-Z closed 1 week ago

MyGit-Z commented 1 month ago

请问有大佬已经在2.2.0版本上,数据源由mysql切换至pg了嘛?有的话希望可以给一下具体的sql文件

dosubot[bot] commented 1 month ago

For migrating from MySQL to PostgreSQL in Apollo 2.2.0, the release notes and pull requests indicate support for PostgreSQL, including specific fixes and compatibility improvements. However, there doesn't seem to be a direct mention of SQL migration files from MySQL to PostgreSQL. The process might require more than just SQL scripts, involving configuration adjustments and compatibility checks for PostgreSQL features.

The repository includes a tool, ApolloSqlConverter.java, for converting SQL templates for different databases, which might be part of the migration process. This tool suggests a framework for adapting SQL scripts across different databases, potentially useful for your migration needs.

For detailed steps or specific SQL files for migration, these might not be readily available in the repository. It could be beneficial to look into the mentioned pull requests and compatibility fixes as a starting point for understanding the required changes. If you need further assistance or have more specific queries, feel free to ask.

#### Details **Sources** - [changes/changes-2.2.0.md](https://github.com/apolloconfig/apollo/blob/master/changes/changes-2.2.0.md) - [apollo-build-sql-converter/src/main/java/com/ctrip/framework/apollo/build/sql/converter/ApolloSqlConverter.java](https://github.com/apolloconfig/apollo/blob/master/apollo-build-sql-converter/src/main/java/com/ctrip/framework/apollo/build/sql/converter/ApolloSqlConverter.java)
**About Dosu** This response is meant to be useful and save you time. It is **not meant to be a precise solution**, but rather a starting point for your own research. Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

To continue the conversation, mention @dosu.

stale[bot] commented 2 weeks ago

This issue has been automatically marked as stale because it has not had activity in the last 30 days. It will be closed in 7 days unless it is tagged "help wanted" or other activity occurs. Thank you for your contributions.

stale[bot] commented 1 week ago

This issue has been automatically closed because it has not had activity in the last 7 days. If this issue is still valid, please ping a maintainer and ask them to label it as "help wanted". Thank you for your contributions.