Beginner question on PostgreSQL

[Sarbartha Bandyopadhyay]

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