On 2009-07-08, Andreas Wenk <a.wenk@netzmeister-st-pauli.de> wrote:
> 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.
if it's "trust" any user can do
~postgres/8.4/bin/createdb -U postgres -p 5433 test