Thread: Problem in 'User Securities' in postgres
Hi All,
I gave my previous mail on 'user securities' with subject 'probelm in usersecurities'. In that i mentioned that access to database on localhost is allowed without password. I got suggestion that to go through 'clinet authentication'.
As per that document i changed the 'pg_hba.conf' file as follows.
local all password
while accessing database it is asking for password, if i give database password, i am getting error as 'password authentication failure for user 'xxxx' ' .
host all x.x.x.x x.x.x.x password
If i try to connect through pg_access (tcp/Ip) connection. If I supplied user password i got same above error.
In case of 'trust' connection it is allowing every body without password checking.
How can i use password authentication.
Another question shall we use 'unix securities' using Postgres like 'windows-nt and sqlserver'. and what security protocol is maintaining by postgres.
thanks alot for any suggestion.
with best regards,
bhaskar