my_tuples_list = [(-171.01155, -11.05869), (-171.01116, -11.06022), (
    -171.01138, -11.07814), (-171.01708, -11.08953), (-171.01963, -11.09463
    ), (-171.03217, -11.10509), (-171.04886, -11.10929), (-171.07441, 
    -11.11013), (-171.09834, -11.10787), (-171.10588, -11.10552), (
    -171.12063, -11.10091), (-171.13384, -11.09055), (-171.13385, -11.09055
    ), (-171.13386, -11.09054), (-171.13387, -11.09053), (-171.13386, 
    -11.09053), (-171.13384, -11.09053), (-171.13383, -11.09053), (
    -171.13529, -11.08719), (-171.13966, -11.07717), (-171.14112, -11.07383
    ), (-171.14113, -11.07382), (-171.14114, -11.07382), (-171.14115, 
    -11.07382), (-171.14191, -11.06076), (-171.14118, -11.04661), (
    -171.14116, -11.04622), (-171.13745, -11.03009), (-171.12577, -11.0156),
    (-171.1114, -11.00379), (-171.09488, -10.9978), (-171.08485, -10.9975),
    (-171.07463, -10.9972), (-171.05771, -10.99903), (-171.05163, -11.00014
    ), (-171.03634, -11.00291), (-171.03358, -11.00409), (-171.0279, 
    -11.00652), (-171.01928, -11.01225), (-171.01876, -11.01339), (
    -171.01407, -11.0237), (-171.01238, -11.04712)]
my_point_list = [Point(p[0], p[1]) for p in my_tuples_list]
conn = psycopg2.connect(database='cpn')
cursor = conn.cursor()
insert = 'insert into t (p) values (%s::point[])'
cursor.execute(insert, (my_point_list,))
conn.commit()
Inserting an array of points into postgres from python