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.
