On 2009-07-08, Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
