mysql到postgresql转换问题 - wsl上的pgloader
我正在尝试通过WSL PGLOADER将MySQL 5.6转换为PostgreSQL 14，并使用以下命令将其转换为PostgreSQL。
pgloader mysql://root:[email protected]/dbname1 postgresql://postgres:[email protected]/dbname1
但这显示在以下错误，请帮助我解决此问题。
2022-05-17T09:16:03.014000Z LOG pgloader version "3.6.1"
2022-05-17T09:16:03.016000Z LOG Data errors in '/tmp/pgloader/'
2022-05-17T09:16:03.122000Z LOG Migrating from #<MYSQL-CONNECTION mysql://[email protected]:3306/dbname1{1005D97DD3}>
2022-05-17T09:16:03.122000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://[email protected]:5432/dbname1{1005FB32F3}>
KABOOM!
INFO: Control stack guard page unprotected
Control stack guard page temporarily disabled: proceed with caution
What I am doing here?
Control stack exhausted (no more space for function call frames).
This is probably due to heavily nested or infinitely recursive function
calls, or a tail call that SBCL cannot or has not optimized away.
PROCEED WITH CAUTION.
我已经尝试了Google的几种方法将其转换为PostgreSQL，但它不起作用。
请让我知道是否有任何最佳替代方法将mysql转换为PostgreSQL。我有很大的数据库，因此寻找迁移的最佳方法。
I'm trying to convert MySQL 5.6 to PostgreSQL 14 via WSL pgloader with below command.
pgloader mysql://root:[email protected]/dbname1 postgresql://postgres:[email protected]/dbname1
But it's showing below error, Please help me to resolve this issue.
2022-05-17T09:16:03.014000Z LOG pgloader version "3.6.1"
2022-05-17T09:16:03.016000Z LOG Data errors in '/tmp/pgloader/'
2022-05-17T09:16:03.122000Z LOG Migrating from #<MYSQL-CONNECTION mysql://[email protected]:3306/dbname1{1005D97DD3}>
2022-05-17T09:16:03.122000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://[email protected]:5432/dbname1{1005FB32F3}>
KABOOM!
INFO: Control stack guard page unprotected
Control stack guard page temporarily disabled: proceed with caution
What I am doing here?
Control stack exhausted (no more space for function call frames).
This is probably due to heavily nested or infinitely recursive function
calls, or a tail call that SBCL cannot or has not optimized away.
PROCEED WITH CAUTION.
I have tried several methods from Google to convert to PostgreSQL, but it's not working.
Please let me know if there is any best alternative way to convert MySQL to PostgreSQL. I have a big size of database, so looking for the best way for migration.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我通过使用Ubuntu 20.4重新安装WSL2来解决此问题，现在正常工作。
谢谢你！
I have fixed this by reinstalling the WSL2 with ubuntu 20.4 it's working perfectly now.
Thank you!