Using cloud_sql_proxy from google activly both on self host and on resources

from my understanding the cloudproxy supports multiple instances

Ah yes you are correct, you should be able to proxy two instances with a single cloud_sql_proxy

Next thing I would try is to swap the order of the two instances, so in your example make "instance connection name 2" the first argument so it receives connections through localhost:5432. If you can connect to instance 1 but cannot connect to instance 2 in that case, that suggests the problem is with the DB.