| From: | Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr> |
|---|---|
| To: | Markus Jais <markusjais(at)yahoo(dot)de> |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: phpPgAdmin problem |
| Date: | 2002-07-30 10:58:18 |
| Message-ID: | Pine.LNX.4.44.0207301300490.25267-100000@oper.metu.edu.tr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
On 29 Jul 2002, Markus Jais wrote:
> I get a login screen prompting for username and password
> I entered postgres and the linux postword for postgres
> but that didn't work
Well, you must use the password that you assigned to "postgres" user using
pg_passwd.
In etc/shadow, you could have an entry as below:
postgres:!!:11723:0:99999:7:::
This means that, postgres user will NOT accept ANY password. IMHO, maybe
this is a better security issue than assigning a passwd to postgres user.
You could disable the password by using passwd command with -l parameter.
This option is used to lock the specified account and it is available to
root only.
> I thought that I shouldn't get a login screen at all.
If so, anyone could access you db :)
Regards and best wished.
--
Devrim GUNDUZ
devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr
Web : http://devrim.oper.metu.edu.tr
-------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ewald Geschwinde | 2002-07-30 11:25:31 | Re: advanced book ? |
| Previous Message | valerie | 2002-07-30 07:11:00 | Top N Records Per Group |