PostgreSQL - automatically create a database for users on first login
No that's not possible. 

Even if it was possible: as you need to specify a database when you connect, the new database wouldn't be the one the user connected to (and there is no way to re-route the user to the newly created one).