In that case, this value does not specify a “ directory” but a prefix from which the actual socket name is computed in the same manner as for the file-system namespace. An empty value specifies not listening on any Unix-domain sockets, in which case only TCP/IP sockets can be used to connect to the server.Ī value that starts with specifies that a Unix-domain socket in the abstract namespace should be created (currently supported on Linux only). Whitespace between entries is ignored surround a directory name with double quotes if you need to include whitespace or commas in the name. Multiple sockets can be created by listing multiple directories separated by commas. Specifies the directory of the Unix-domain socket(s) on which the server is to listen for connections from client applications. This parameter can only be set at server start. The value must be less than max_connections minus reserved_connections. The connection slots reserved by this parameter are intended as final reserve for emergency use after the slots reserved by reserved_connections have been exhausted. Whenever the number of active concurrent connections is at least max_connections minus superuser_reserved_connections, new connections will be accepted only for superusers. ![]() At most max_connections connections can ever be active simultaneously. superuser_reserved_connections ( integer) #ĭetermines the number of connection “ slots” that are reserved for connections by PostgreSQL superusers. The value must be less than max_connections minus superuser_reserved_connections. If superuser_reserved_connections or fewer connection slots are available, new connections will be accepted only for superusers. Whenever the number of free connection slots is greater than superuser_reserved_connections but less than or equal to the sum of superuser_reserved_connections and reserved_connections, new connections will be accepted only for superusers and roles with privileges of pg_use_reserved_connections. reserved_connections ( integer) #ĭetermines the number of connection “ slots” that are reserved for connections by roles with privileges of the pg_use_reserved_connections role. Otherwise, queries will not be allowed in the standby server. When running a standby server, you must set this parameter to the same or higher value than on the primary server. The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb). max_connections ( integer) #ĭetermines the maximum number of concurrent connections to the database server. ![]() Note that the same port number is used for all IP addresses the server listens on. The TCP port the server listens on 5432 by default. ![]() While client authentication ( Chapter 21) allows fine-grained control over who can access the server, listen_addresses controls which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces. The default value is localhost, which allows only local TCP/IP “ loopback” connections to be made. A warning will be emitted for any TCP/IP address which cannot be opened. If the list is not empty, the server will start if it can listen on at least one TCP/IP address. If the list is empty, the server does not listen on any IP interface at all, in which case only Unix-domain sockets can be used to connect to it. ![]() The entry 0.0.0.0 allows listening for all IPv4 addresses and :: allows listening for all IPv6 addresses. The special entry * corresponds to all available IP interfaces. The value takes the form of a comma-separated list of host names and/or numeric IP addresses. Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |