I've built this out using MySQL or Aurora for the RDS... but is it possible to use PostgreSQL?
All of the documentation mentions MySQL (or MySQL like) so I am assuming it won't work and that CA doesn't support it.
Is it technically possible? maybe... is it supported? no. Gateway only supports MySQL as its configuration database.