Disclaimer: Not sure if they will surprise you
A role can be a user
This is STUPID ! It’s anti common sense.
utf8 charset supports 4-byte chars
In mysql you have to specify the charset to be “utf8mb4”, but in postgres it can just be “utf8”
When you create a new database, any role is allowed to create objects in the public schema of this database
This is crazy. You should revoke the creating permissions of other roles. See https://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql/39029296#39029296