bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
reserved_connections |
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |
bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
reserved_connections |
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |
bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
|
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |
bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
|
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |
bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
|
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |
bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
|
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |
bonjour
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Enables advertising the server via Bonjour. |
Data type |
boolean |
Default value |
off |
Allowed values |
off |
Parameter type |
read-only |
Documentation |
bonjour |
bonjour_name
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the Bonjour service name. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
bonjour_name |
listen_addresses
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the host name or IP address(es) to listen to. |
Data type |
string |
Default value |
* |
Allowed values |
* |
Parameter type |
read-only |
Documentation |
listen_addresses |
max_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the maximum number of concurrent connections to the database server. |
Data type |
integer |
Default value |
Depends on resources (vCores, RAM, or disk space) allocated to the server. |
Allowed values |
25-5000 |
Parameter type |
static |
Documentation |
max_connections |
Azure-specific notes
The default value for the max_connections
server parameter is calculated when you provision the instance of Azure Database for PostgreSQL flexible server, based on the product name that you select for its compute. Any subsequent changes of product selection to the compute that supports the flexible server don't have any effect on the default value for the max_connections
server parameter of that instance.
Every time you change the product assigned to an instance, you should also adjust the value for the max_connections
parameter according to the values in the following formula.
In virtual machines with up to 2 GiB of memory, the formula used to compute the value of max_connections
is memoryGib * 25
.
In virtual machines with more than 2 GiB, the formula used to compute the value of max_connections
is MIN(memoryGib * 0.1049164697034809, 5000)
.
Based on the previous formula, the following table lists the values this server parameter would be set to depending on the amount of memory provisioned:
Memory size |
max_connections |
2 GiB |
50 |
4 GiB |
429 |
8 GiB |
859 |
16 GiB |
1718 |
32 GiB |
3437 |
48 GiB |
5000 |
64 GiB |
5000 |
80 GiB |
5000 |
128 GiB |
5000 |
160 GiB |
5000 |
192 GiB |
5000 |
256 GiB |
5000 |
384 GiB |
5000 |
432 GiB |
5000 |
672 GiB |
5000 |
Refer to Maximum connections for more information about this parameter in Azure Database for Flexible Server.
port
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the TCP port the server listens on. |
Data type |
integer |
Default value |
5432 |
Allowed values |
5432 |
Parameter type |
read-only |
Documentation |
port |
reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connections slots reserved for replication users and super users. |
Data type |
integer |
Default value |
5 |
Allowed values |
5 |
Parameter type |
read-only |
Documentation |
|
superuser_reserved_connections
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the number of connection slots reserved for superusers. |
Data type |
integer |
Default value |
10 |
Allowed values |
10 |
Parameter type |
read-only |
Documentation |
superuser_reserved_connections |
unix_socket_directories
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the directories where Unix-domain sockets will be created. |
Data type |
string |
Default value |
/tmp,/tmp/tuning_sockets |
Allowed values |
/tmp,/tmp/tuning_sockets |
Parameter type |
read-only |
Documentation |
unix_socket_directories |
unix_socket_group
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the owning group of the Unix-domain socket. |
Data type |
string |
Default value |
|
Allowed values |
|
Parameter type |
read-only |
Documentation |
unix_socket_group |
unix_socket_permissions
Attribute |
Value |
Category |
Connections and Authentication / Connection Settings |
Description |
Sets the access permissions of the Unix-domain socket. |
Data type |
integer |
Default value |
0777 |
Allowed values |
0777 |
Parameter type |
read-only |
Documentation |
unix_socket_permissions |