Re: [GENERAL] Socket Connection Authentication

2015-07-08 Thread Naveed Shaikh
The peer authentication method works by obtaining the client's operating system user name from the kernel and using it as the allowed database user name (with optional user name mapping). This method is only supported on local connections. *Please check the below steps as an Example:* *1>>* Creat

Re: [GENERAL] Socket Connection Authentication

2015-07-08 Thread John R Pierce
On 7/8/2015 11:32 PM, basti wrote: When I try local database user md5 I get the error: "Peer authentication failed for user ..." Is it possible to authenticate a user with md5 via socket connection? yes, it is, I do it all the time. was this the first local line, or at least in front

[GENERAL] Socket Connection Authentication

2015-07-08 Thread basti
Hello, I try to use PHP with Postgresq1 socket connection. All works fine with following entry in pg_hba.conf local database user trust or local database user peer map=someuser pg_ident.conf # MAPNAME SYSTEM-USERNAME PG-USERNAME someuserwww-data