| From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
|---|---|
| To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | [Re: Password?] |
| Date: | 2009-07-08 10:24:16 |
| Message-ID: | 4A5473D0.3060906@netzmeister-st-pauli.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2009-07-08 10:39:37 | Re: ZFS prefetch considered evil? |
| Previous Message | Andreas Wenk | 2009-07-08 10:17:23 | Re: Password? |