If I run checkpoint from psql, is it applied to all the databases?
What if I do it though an API? When connecting with psycopg2, I'm forced to specify a database name, if I use "dbname=postgres", and execute "checkpoint;", is it applied to all the databases?
Yes. CHECKPOINT is more a cluster-wide operation, rather than a database one.