Beginner question on PostgreSQL
Sarbartha Bandyopadhyay
sbandy at umd.edu
Sat Dec 18 00:24:37 UTC 2004
On 6:09pm Dec 17, 2004, Rodolfo J. Paiz wrote
> Hey, everyone:
>
> I started my migration process from MySQL to PostgreSQL about two hours
> ago. I've installed the RPM packages (all relevant packages,
> 7.4.6-1.FC3.2 updated today), and I have also installed phpPgAdmin-3.5
> via their RPM package.
>
> Using the text-mode command-line clients, I have managed to create a
> database user "rpaiz" to go with my system user "rpaiz" and I have
> managed to create and access a database "flightlog" owned by that user,
> and as that user. So at least some of these things are working.
>
> However, I cannot seem to access the phpPgAdmin interface. The web page
> does come up properly, but I always get a "login denied" error. It does
> not matter whether I use the "rpaiz" user with no password or with my
> system password. It also does not matter whether I create the database
> user with no password or using the "-P -E" options to add and encrypt
> the password.
>
> Can anyone tell me which part of this I'm doing wrong? I'm reading
> through as many docs as I can as fast as I can, but this is frustrating.
>
> Thanks in advance,
>
>
you need to add something like
local all all trust
host all all 127.0.0.1 255.255.255.0 trust
etc.
in pg_hba.conf
of course those entries are overtly relaxed. you need to
harden it. read the comments in the pg_hba.conf
More information about the users
mailing list