Configurations - List By Server
List all the configurations in a given server.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/servers/{serverName}/configurations?api-version=2017-12-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
resource
|
path | True |
string |
The name of the resource group. The name is case insensitive. |
server
|
path | True |
string |
The name of the server. |
subscription
|
path | True |
string |
The ID of the target subscription. |
api-version
|
query | True |
string |
The API version to use for this operation. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
OK |
|
Other Status Codes |
Error response describing why the operation failed. |
Security
azure_auth
Azure Active Directory OAuth2 Flow
Type:
oauth2
Flow:
implicit
Authorization URL:
https://login.microsoftonline.com/common/oauth2/authorize
Scopes
Name | Description |
---|---|
user_impersonation | impersonate your user account |
Examples
ConfigurationList
Sample Request
Sample Response
{
"value": [
{
"properties": {
"value": "on",
"description": "Enable input of NULL elements in arrays.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/array_nulls",
"name": "array_nulls",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "safe_encoding",
"description": "Sets whether \"\\'\" is allowed in string literals.",
"defaultValue": "safe_encoding",
"dataType": "Enumeration",
"allowedValues": "safe_encoding,on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/backslash_quote",
"name": "backslash_quote",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "hex",
"description": "Sets the output format for bytea.",
"defaultValue": "hex",
"dataType": "Enumeration",
"allowedValues": "escape,hex",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/bytea_output",
"name": "bytea_output",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Check function bodies during CREATE FUNCTION.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/check_function_bodies",
"name": "check_function_bodies",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "sql_ascii",
"description": "Sets the client's character set encoding.",
"defaultValue": "sql_ascii",
"dataType": "Enumeration",
"allowedValues": "BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/client_encoding",
"name": "client_encoding",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "notice",
"description": "Sets the message levels that are sent to the client.",
"defaultValue": "notice",
"dataType": "Enumeration",
"allowedValues": "debug5,debug4,debug3,debug2,debug1,log,notice,warning,error",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/client_min_messages",
"name": "client_min_messages",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "partition",
"description": "Enables the planner to use constraints to optimize queries.",
"defaultValue": "partition",
"dataType": "Enumeration",
"allowedValues": "partition,on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/constraint_exclusion",
"name": "constraint_exclusion",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0.005",
"description": "Sets the planner's estimate of the cost of processing each index entry during an index scan.",
"defaultValue": "0.005",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/cpu_index_tuple_cost",
"name": "cpu_index_tuple_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0.0025",
"description": "Sets the planner's estimate of the cost of processing each operator or function call.",
"defaultValue": "0.0025",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/cpu_operator_cost",
"name": "cpu_operator_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0.01",
"description": "Sets the planner's estimate of the cost of processing each tuple (row).",
"defaultValue": "0.01",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/cpu_tuple_cost",
"name": "cpu_tuple_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0.1",
"description": "Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.",
"defaultValue": "0.1",
"dataType": "Numeric",
"allowedValues": "0-1",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/cursor_tuple_fraction",
"name": "cursor_tuple_fraction",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "iso, mdy",
"description": "Sets the display format for date and time values.",
"defaultValue": "iso, mdy",
"dataType": "String",
"allowedValues": "(iso|postgres|sql|german)\\,\\s(dmy|mdy|ymd)",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/datestyle",
"name": "datestyle",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "1000",
"description": "Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock.",
"defaultValue": "1000",
"dataType": "Integer",
"allowedValues": "1-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/deadlock_timeout",
"name": "deadlock_timeout",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs each query's parse tree.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/debug_print_parse",
"name": "debug_print_parse",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs each query's execution plan.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/debug_print_plan",
"name": "debug_print_plan",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs each query's rewritten parse tree.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/debug_print_rewritten",
"name": "debug_print_rewritten",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "100",
"description": "Sets the default statistics target.",
"defaultValue": "100",
"dataType": "Integer",
"allowedValues": "1-10000",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/default_statistics_target",
"name": "default_statistics_target",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "pg_catalog.english",
"description": "Sets default text search configuration.",
"defaultValue": "pg_catalog.english",
"dataType": "String",
"allowedValues": "[A-Za-z\\._]+",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/default_text_search_config",
"name": "default_text_search_config",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Sets the default deferrable status of new transactions.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/default_transaction_deferrable",
"name": "default_transaction_deferrable",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "read committed",
"description": "Sets the transaction isolation level of each new transaction.",
"defaultValue": "read committed",
"dataType": "Enumeration",
"allowedValues": "serializable,repeatable read,read committed,read uncommitted",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/default_transaction_isolation",
"name": "default_transaction_isolation",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Sets the default read-only status of new transactions.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/default_transaction_read_only",
"name": "default_transaction_read_only",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Create new tables with OIDs by default.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/default_with_oids",
"name": "default_with_oids",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of bitmap-scan plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_bitmapscan",
"name": "enable_bitmapscan",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of hashed aggregation plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_hashagg",
"name": "enable_hashagg",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of hash join plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_hashjoin",
"name": "enable_hashjoin",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of index-only-scan plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_indexonlyscan",
"name": "enable_indexonlyscan",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of index-scan plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_indexscan",
"name": "enable_indexscan",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of materialization.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_material",
"name": "enable_material",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of merge join plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_mergejoin",
"name": "enable_mergejoin",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of nested-loop join plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_nestloop",
"name": "enable_nestloop",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of sequential-scan plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_seqscan",
"name": "enable_seqscan",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of explicit sort steps.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_sort",
"name": "enable_sort",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables the planner's use of TID scan plans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/enable_tidscan",
"name": "enable_tidscan",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Warn about backslash escapes in ordinary string literals.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/escape_string_warning",
"name": "escape_string_warning",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Terminate session on any error.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/exit_on_error",
"name": "exit_on_error",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the number of digits displayed for floating-point values.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "-15-3",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/extra_float_digits",
"name": "extra_float_digits",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "8",
"description": "Sets the FROM-list size beyond which subqueries are not collapsed.",
"defaultValue": "8",
"dataType": "Integer",
"allowedValues": "1-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/from_collapse_limit",
"name": "from_collapse_limit",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enables genetic query optimization.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo",
"name": "geqo",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "5",
"description": "GEQO: effort is used to set the default for other GEQO parameters.",
"defaultValue": "5",
"dataType": "Integer",
"allowedValues": "1-10",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo_effort",
"name": "geqo_effort",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "GEQO: number of iterations of the algorithm.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo_generations",
"name": "geqo_generations",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "GEQO: number of individuals in the population.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo_pool_size",
"name": "geqo_pool_size",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0.0",
"description": "GEQO: seed for random path selection.",
"defaultValue": "0.0",
"dataType": "Numeric",
"allowedValues": "0-1",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo_seed",
"name": "geqo_seed",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "2.0",
"description": "GEQO: selective pressure within the population.",
"defaultValue": "2.0",
"dataType": "Numeric",
"allowedValues": "1.5-2",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo_selection_bias",
"name": "geqo_selection_bias",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "12",
"description": "Sets the threshold of FROM items beyond which GEQO is used.",
"defaultValue": "12",
"dataType": "Integer",
"allowedValues": "2-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/geqo_threshold",
"name": "geqo_threshold",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the maximum allowed result for exact search by GIN.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/gin_fuzzy_search_limit",
"name": "gin_fuzzy_search_limit",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "postgres",
"description": "Sets the display format for interval values.",
"defaultValue": "postgres",
"dataType": "Enumeration",
"allowedValues": "postgres,postgres_verbose,sql_standard,iso_8601",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/intervalstyle",
"name": "intervalstyle",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "8",
"description": "Sets the FROM-list size beyond which JOIN constructs are not flattened.",
"defaultValue": "8",
"dataType": "Integer",
"allowedValues": "1-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/join_collapse_limit",
"name": "join_collapse_limit",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/lock_timeout",
"name": "lock_timeout",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs each checkpoint.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_checkpoints",
"name": "log_checkpoints",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs each successful connection.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_connections",
"name": "log_connections",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs end of a session, including duration.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_disconnections",
"name": "log_disconnections",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs the duration of each completed SQL statement.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_duration",
"name": "log_duration",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "default",
"description": "Sets the verbosity of logged messages.",
"defaultValue": "default",
"dataType": "Enumeration",
"allowedValues": "terse,default,verbose",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_error_verbosity",
"name": "log_error_verbosity",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Logs long lock waits.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_lock_waits",
"name": "log_lock_waits",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "-1",
"description": "Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.",
"defaultValue": "-1",
"dataType": "Integer",
"allowedValues": "-1-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_min_duration_statement",
"name": "log_min_duration_statement",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "error",
"description": "Causes all statements generating error at or above this level to be logged.",
"defaultValue": "error",
"dataType": "Enumeration",
"allowedValues": "debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_min_error_statement",
"name": "log_min_error_statement",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "warning",
"description": "Sets the message levels that are logged.",
"defaultValue": "warning",
"dataType": "Enumeration",
"allowedValues": "debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_min_messages",
"name": "log_min_messages",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "none",
"description": "Sets the type of statements logged.",
"defaultValue": "none",
"dataType": "Enumeration",
"allowedValues": "none,ddl,mod,all",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_statement",
"name": "log_statement",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "64",
"description": "Sets the maximum number of locks per transaction.",
"defaultValue": "64",
"dataType": "Integer",
"allowedValues": "10-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/max_locks_per_transaction",
"name": "max_locks_per_transaction",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "64",
"description": "Sets the maximum number of predicate locks per transaction.",
"defaultValue": "64",
"dataType": "Integer",
"allowedValues": "10-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/max_pred_locks_per_transaction",
"name": "max_pred_locks_per_transaction",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the maximum number of simultaneously prepared transactions.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-8388607",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/max_prepared_transactions",
"name": "max_prepared_transactions",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "When generating SQL fragments, quote all identifiers.",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/quote_all_identifiers",
"name": "quote_all_identifiers",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "4.0",
"description": "Sets the planner's estimate of the cost of a nonsequentially fetched disk page.",
"defaultValue": "4.0",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/random_page_cost",
"name": "random_page_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "\"$user\", public",
"description": "Sets the schema search order for names that are not schema-qualified.",
"defaultValue": "\"$user\", public",
"dataType": "String",
"allowedValues": "[A-Za-z.\"$, ]+",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/search_path",
"name": "search_path",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "1.0",
"description": "Sets the planner's estimate of the cost of a sequentially fetched disk page.",
"defaultValue": "1.0",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/seq_page_cost",
"name": "seq_page_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Causes subtables to be included by default in various commands.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/sql_inheritance",
"name": "sql_inheritance",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Causes '...' strings to treat backslashes literally.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/standard_conforming_strings",
"name": "standard_conforming_strings",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/statement_timeout",
"name": "statement_timeout",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Enable synchronized sequential scans.",
"defaultValue": "on",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/synchronize_seqscans",
"name": "synchronize_seqscans",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "on",
"description": "Sets the current transaction's synchronization level.",
"defaultValue": "on",
"dataType": "Enumeration",
"allowedValues": "local,remote_write,on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/synchronous_commit",
"name": "synchronous_commit",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Treats \"expr=NULL\" as \"expr IS NULL\".",
"defaultValue": "off",
"dataType": "Boolean",
"allowedValues": "on,off",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/transform_null_equals",
"name": "transform_null_equals",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "base64",
"description": "Sets how binary values are to be encoded in XML.",
"defaultValue": "base64",
"dataType": "Enumeration",
"allowedValues": "base64,hex",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/xmlbinary",
"name": "xmlbinary",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "content",
"description": "Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.",
"defaultValue": "content",
"dataType": "Enumeration",
"allowedValues": "content,document",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/xmloption",
"name": "xmloption",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "off",
"description": "Forces use of parallel query facilities.",
"defaultValue": "off",
"dataType": "Enumeration",
"allowedValues": "off,on,regress",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/force_parallel_mode",
"name": "force_parallel_mode",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the maximum allowed duration of any idling transaction.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-2147483647",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/idle_in_transaction_session_timeout",
"name": "idle_in_transaction_session_timeout",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0",
"description": "Sets the maximum number of parallel processes per executor node.",
"defaultValue": "0",
"dataType": "Integer",
"allowedValues": "0-1024",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/max_parallel_workers_per_gather",
"name": "max_parallel_workers_per_gather",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "8388608",
"description": "Sets the minimum size of relations to be considered for parallel scan.",
"defaultValue": "8388608",
"dataType": "Integer",
"allowedValues": "0-715827882",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/min_parallel_relation_size",
"name": "min_parallel_relation_size",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "1000",
"description": "Sets the planner's estimate of the cost of starting up worker processes for parallel query.",
"defaultValue": "1000",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/parallel_setup_cost",
"name": "parallel_setup_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "0.1",
"description": "Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.",
"defaultValue": "0.1",
"dataType": "Numeric",
"allowedValues": "0-1.79769e+308",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/parallel_tuple_cost",
"name": "parallel_tuple_cost",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
},
{
"properties": {
"value": "3",
"description": "Sets how many days a log file is saved for.",
"defaultValue": "3",
"dataType": "Integer",
"allowedValues": "1-7",
"source": "system-default"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/servers/testserver/configurations/log_retention_days",
"name": "log_retention_days",
"type": "Microsoft.DBforPostgreSQL/servers/configurations"
}
]
}
Definitions
Name | Description |
---|---|
Cloud |
An error response from the Batch service. |
Configuration |
Represents a Configuration. |
Configuration |
A list of server configurations. |
Error |
The resource management error additional info. |
Error |
Error Response |
CloudError
An error response from the Batch service.
Name | Type | Description |
---|---|---|
error |
Error Response |
Configuration
Represents a Configuration.
Name | Type | Description |
---|---|---|
id |
string |
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
name |
string |
The name of the resource |
properties.allowedValues |
string |
Allowed values of the configuration. |
properties.dataType |
string |
Data type of the configuration. |
properties.defaultValue |
string |
Default value of the configuration. |
properties.description |
string |
Description of the configuration. |
properties.source |
string |
Source of the configuration. |
properties.value |
string |
Value of the configuration. |
type |
string |
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" |
ConfigurationListResult
A list of server configurations.
Name | Type | Description |
---|---|---|
value |
The list of server configurations. |
ErrorAdditionalInfo
The resource management error additional info.
Name | Type | Description |
---|---|---|
info |
object |
The additional info. |
type |
string |
The additional info type. |
ErrorResponse
Error Response
Name | Type | Description |
---|---|---|
additionalInfo |
The error additional info. |
|
code |
string |
The error code. |
details |
The error details. |
|
message |
string |
The error message. |
target |
string |
The error target. |