Compare and contrast the high availability and transactions architecture of PostgreSQL, MongoDB, and YugabyteDB databases.