To do this, set the unix_socket_permissions (and possibly unix_socket_group) configuration parameters as described in Section 19.3. However, you might be able to use trust even on a multiuser machine, if you restrict access to the server's Unix-domain socket file using file-system permissions. It is usually not appropriate by itself on a multiuser machine. Trust authentication is appropriate and very convenient for local connections on a single-user workstation. This method should only be used when there is adequate operating-system-level protection on connections to the server. Of course, restrictions made in the database and user columns still apply. When trust authentication is specified, PostgreSQL assumes that anyone who can connect to the server is authorized to access the database with whatever database user name they specify (even superuser names).
0 kommentar(er)
