Re: [Re: Password?]

Yes,
Its the currently logged on user.

--- On Wed, 7/8/09, Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> wrote:

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
Subject: [Re: [GENERAL] Password?]
To: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Date: Wednesday, July 8, 2009, 3:54 PM

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(at)duke-linux:~/8.4/bin$ ./createdb test -p 5433
postgres(at)duke-linux:~/8.4/bin$

auth method in pg_hba.conf is trust in this case.

-- Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general