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. Whenever the number of active concurrent connections is at least max_connections minus superuser_reserved_connections, new connections will be accepted only for superusers, and no new replication connections will be accepted. 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. 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. 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 kommentar(er)
