Is it possible to create a database to be owned by a user that only exists to postgresql or do they have to be shell accounts as well.
$ createdb --owner=testcon testdb but the owner ends up being postgres I'm planning to create a different database for each different project I have. I want these users to be only used to connect to the db, not have a shell account. So far, my only experience has been on a closed network where all users already have shell access. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match