Muokkaa

Jaa

Connections and Authentication / Connection Settings

  • Artikkeli

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