Jonathan Villa <jvilla(at)innovativesource(dot)net> writes:
> $ createdb --owner=testcon testdb
> but the owner ends up being postgres
I don't think so.
$ createuser testcon
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
$ createdb --owner=testcon testdb
CREATE DATABASE
$ psql -l
List of databases
Name | Owner | Encoding
------------+---------+-----------
pltest | tgl | SQL_ASCII
regression | tgl | SQL_ASCII
template0 | tgl | SQL_ASCII
template1 | tgl | SQL_ASCII
testdb | testcon | SQL_ASCII
(5 rows)
$
regards, tom lane