postgress security

[JJJ777]

I think a good security balance would be to allow local users to connect using their username without a password / with a different username & password. However i haven't figured out how to actually do this; my attempts so far at what look logical seem to fail.

rite now i have create 3 diffrent user for postgress in table pg_shadow with different privilege(GRANTED diffrently) ..my problem is how to make it login equal with the username & password at the login page..
now i only set dbusername='pgsql' in my config file (fix)..

tq..

 

[newbiepg]

you need to change your pg_hba.conf file

in Redhat 7.3 it is located in /var/lib/pgsql/data

Otherwise log in as root, type locate pg_hba.conf to find it

There are separate login permissions mentioned in the explannation there for local users, network users and users for a different IP.

In the authenticate section you can set password requirements