一、使用pgloader進行遷移
1. 安裝pgloader：
sudo apt-get install pgloader
2. 使用pgloader遷移資料：
pgloader mysql://username:password@localhost/source_db postgresql://username:password@localhost/destination_db
Q、異常解析
KABOOM!
FATAL error: Failed to connect to pgsql at "..." (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).
An unhandled error condition has been signalled:
Failed to connect to pgsql at ".xx.xx.xx" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).
What I am doing here?
Failed to connect to pgsql at "xx.xx.xx.xx" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).