Configurations - List By Server
Wyświetl listę wszystkich konfiguracji na danym serwerze.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/servers/{serverName}/configurations?api-version=2017-12-01Parametry identyfikatora URI
| Nazwa | W | Wymagane | Typ | Opis |
|---|---|---|---|---|
|
resource
|
path | True |
string |
Nazwa grupy zasobów. W nazwie jest uwzględniana wielkość liter. |
|
server
|
path | True |
string |
Nazwa serwera. |
|
subscription
|
path | True |
string |
Identyfikator subskrypcji docelowej. |
|
api-version
|
query | True |
string |
Wersja interfejsu API do użycia dla tej operacji. |
Odpowiedzi
| Nazwa | Typ | Opis |
|---|---|---|
| 200 OK |
OK |
|
| Other Status Codes |
Odpowiedź na błąd opisująca, dlaczego operacja nie powiodła się. |
Zabezpieczenia
azure_auth
Przepływ OAuth2 usługi Azure Active Directory
Type:
oauth2
Flow:
implicit
Authorization URL:
https://login.microsoftonline.com/common/oauth2/authorize
Scopes
| Nazwa | Opis |
|---|---|
| user_impersonation | personifikacja konta użytkownika |
Przykłady
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"
}
]
}Definicje
| Nazwa | Opis |
|---|---|
|
Cloud |
Odpowiedź na błąd z usługi Batch. |
| Configuration |
Reprezentuje konfigurację. |
|
Configuration |
Lista konfiguracji serwera. |
|
Error |
Dodatkowe informacje o błędzie zarządzania zasobami. |
|
Error |
Odpowiedź na błąd |
CloudError
Odpowiedź na błąd z usługi Batch.
| Nazwa | Typ | Opis |
|---|---|---|
| error |
Odpowiedź na błąd |
Configuration
Reprezentuje konfigurację.
| Nazwa | Typ | Opis |
|---|---|---|
| id |
string |
W pełni kwalifikowany identyfikator zasobu dla zasobu. Ex — /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
| name |
string |
Nazwa zasobu |
| properties.allowedValues |
string |
Dozwolone wartości konfiguracji. |
| properties.dataType |
string |
Typ danych konfiguracji. |
| properties.defaultValue |
string |
Wartość domyślna konfiguracji. |
| properties.description |
string |
Opis konfiguracji. |
| properties.source |
string |
Źródło konfiguracji. |
| properties.value |
string |
Wartość konfiguracji. |
| type |
string |
Typ zasobu. Np. "Microsoft.Compute/virtualMachines" lub "Microsoft.Storage/storageAccounts" |
ConfigurationListResult
Lista konfiguracji serwera.
| Nazwa | Typ | Opis |
|---|---|---|
| value |
Lista konfiguracji serwera. |
ErrorAdditionalInfo
Dodatkowe informacje o błędzie zarządzania zasobami.
| Nazwa | Typ | Opis |
|---|---|---|
| info |
object |
Dodatkowe informacje. |
| type |
string |
Dodatkowy typ informacji. |
ErrorResponse
Odpowiedź na błąd
| Nazwa | Typ | Opis |
|---|---|---|
| additionalInfo |
Dodatkowe informacje o błędzie. |
|
| code |
string |
Kod błędu. |
| details |
Szczegóły błędu. |
|
| message |
string |
Komunikat o błędzie. |
| target |
string |
Element docelowy błędu. |