Tl;dr: postgresql service does not start properly when installed as a package using cloud-init.
And I can't figure out if I am doing something wrong, if the AMI is no good, if the package has problems, ... I reckon I cannot be the first person to use Postgres on Ubuntu Vivid, but I have been hammering my head against the wall with this for hours.