Serge Fonville schrieb:
>> *argh* - more detailed to avoid confusion. The auth method 'password' in
>> pg_hba.conf means, that you will be asked for a password for the user you
>> try to create a db with. If no user is given (with createdb -U [username]),
>> this user is postgres ...
>
> Wasn't it that it uses the currently logged on user is used if no user
> is specified?
correct - so this will be postgres because other users are not allowed to use these
programs ...
/var/lib/postgresql/8.4/bin$ ./createdb test -p 5433
createdb: could not connect to database postgres: FATAL: role "duke" does not exist
$ sudo su postgres
postgres@duke-linux:~/8.4/bin$ ./createdb test -p 5433
postgres@duke-linux:~/8.4/bin$
auth method in pg_hba.conf is trust in this case.