datax同步pg数据库数据

datax版本3.0
python支持2和3
jdk1.8

json文件如下，自己已跑通!
参考官网:https://github.com/alibaba/DataX/

{
    "job": {
         "setting": {
            "speed": {
                "channel": 1
            }
        },

        "content": [
            {
                "reader": {
                    "name": "postgresqlreader",
                    "parameter": {
                        "username": "***",
                        "password": "***",
                        "where": "", --可以不写
                        "connection": [
                            {
                                "querySql": [
                                    "select * from 模式名字.表名;"
                                ],
                                "jdbcUrl": [
                                    "jdbc:postgresql://192.**.**.**:5432/数据库名字"
                                ]
                            }
                        ]
                    }
                },
               "writer": {
					"name": "postgresqlwriter",
					"parameter": {
					    "batchSize":"10000",
						"username": "***",
						"password": "***",
						"column": [
							"score","name","age"
						],
						"preSql": [
             						
         					   ],						
						"connection": [
							{
								"jdbcUrl": 
                                "jdbc:postgresql://192.**.**.**:5432/数据库名字",
								"table": [ 
                                             "模式名字.表名"
								]
							}
						]
					}
				}
			}
        ]
    }
}