Yes, Its the currently logged on user.
--- On Wed, 7/8/09, Andreas Wenk <a.w...@netzmeister-st-pauli.de> wrote: From: Andreas Wenk <a.w...@netzmeister-st-pauli.de> Subject: [Re: [GENERAL] Password?] To: "PG-General Mailing List" <pgsql-general@postgresql.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 postg...@duke-linux:~/8.4/bin$ ./createdb test -p 5433 postg...@duke-linux:~/8.4/bin$ auth method in pg_hba.conf is trust in this case. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
