- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 274 pages
ISBN 9781906966072
RRP £9.95 ($14.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>> Ident Authentication over Local Sockets

On systems supporting SO_PEERCRED requests for Unix-domain sockets (currently Linux, FreeBSD, NetBSD, OpenBSD, BSD/OS, and Solaris), ident authentication can also be applied to local connections. PostgreSQL uses SO_PEERCRED to find out the operating system name of the connected client process. In this case, no security risk is added by using ident authentication; indeed it is a preferable choice for local connections on such systems.

On systems without SO_PEERCRED requests, ident authentication is only available for TCP/IP connections. As a work-around, it is possible to specify the localhost address and make connections to this address. This method is trustworthy to the extent that you trust the local ident server.

ISBN 9781906966072The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration GuideSee the print edition