psql to rds

list databases:  \l *;

non-binary way:
export PGPASSWORD=whatever
for F in $(cat dbs); do echo $F; psql -h dt-rds-test.coivvuccn9hs.eu-west-1.rds.amazonaws.com -v -U postgres -d ${F} < ${F}.sql ; done

binary way:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html

# above way doesnt seem to work with roles etc.
psql -h  database-2.coivvuccn9hs.eu-west-1.rds.amazonaws.com  -v -U postgres -d postgres < alldb.dump ;
pg_dumpall -h localhost -p 5033 -U postgres > alldb.dump
for F in $(ls *xml); do sed -i "s;sql:\/\/.*?\/;sql:\/\/database-2.coivvuccn9hs.eu-west-1.rds.amazonaws.com\/;g" $F; done