| From: | "jeff seaman" <jseaman(at)pharsalia(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | user authentication question |
| Date: | 2000-08-02 13:27:41 |
| Message-ID: | NEBBLCGDKLOHFBHHGAAKKEAHCAAA.jseaman@pharsalia.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-interfaces |
I am having trouble understanding the relationship between passwords in the
"passwd" flat file and the system table pg_user. It seems that if I don't
perform a sql "create user" with the "with password" option I can't connect
to the database when I use password authentication even though I used the
pg_passwd command to enter the user. Also pardon my ignorance but is there
a secure way to enter the password using the "create user" command without
exposing the password? I hate to expose a set of "canned" passwords that I
wanted to enter using a script when installing the database.
Thanks in advance.
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-08-02 14:07:48 | Re: [HACKERS] random() function produces wrong range |
| Previous Message | Oakley | 2000-08-02 12:50:13 | Pg.pm install question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-08-02 13:34:22 | Re: mac.c |
| Previous Message | Larry Rosenman | 2000-08-02 13:19:05 | RE: mac.c |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Lloyd-Jones | 2000-08-02 16:33:01 | Is There Anybody in Toronto Running Postgresql with AOLserver? |
| Previous Message | Antonio Navarro Navarro | 2000-08-02 10:34:19 | Python + PostgreSQL |