psycopg2 / python将数据从postgresql复制到Amazon RedShift（postgresql）

I would like to know community opinion regarding the "best way to copy data from PostgreSQL to RedShift with python 2.7.x". I can't use Amazon S3 and RedShift is normal postgresql database but support copy only from S3(I can't use) I would like to know community opinion regardin