Skip to content

postgresql configuration update fails #10037

Open
@yupwei68

Description

@yupwei68

First we get a configuration for postgresql:
Get https://management.azure.com/subscriptions/.../resourceGroups/post-yup/providers/Microsoft.DBforPostgreSQL/servers/post-yup/configurations/azure.replication_support?api-version=2017-12-01:

{"properties":{"value":"logical","description":"Sets the level of replication support (Read Replicas). Any change requires restarting the server to take effect.","defaultValue":"OFF","dataType":"Enumeration","allowedValues":"OFF,REPLICA,LOGICAL","source":"user-override","isConfigPendingRestart":"False","isDynamicConfig":"False"},"id":"/subscriptions/.../resourceGroups/post-yup/providers/Microsoft.DBforPostgreSQL/servers/post-yup/configurations/azure.replication_support","name":"azure.replication_support","type":"Microsoft.DBforPostgreSQL/servers/configurations"}

Then we update the configuration with value "OFF", then we get:
PUT /subscriptions/.../resourceGroups/post-yup/providers/Microsoft.DBforPostgreSQL/servers/post-yup/configurations/azure.replication_support?api-version=2017-12-01

{"properties":{"value":"OFF"}}

{"name":"...","status":"Failed","startTime":"2020-07-06T07:33:58.397Z","error":{"code":"InvalidConfigurationValue","message":"The value 'OFF' for configuration 'azure.replication_support' is not valid. The allowed values are 'REPLICA,LOGICAL'."}}

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions