pulumi-azure-kotlin/com.pulumi.azure.postgresql.kotlin/FlexibleServerConfiguration

FlexibleServerConfiguration

class FlexibleServerConfiguration : KotlinCustomResource

Sets a PostgreSQL Configuration value on a Azure PostgreSQL Flexible Server.

Note: Changes to static server parameters will automatically trigger Azure Flex Server restart. This behavior can be disabled in the provider features block by setting the restart_server_on_configuration_value_change field to false within the postgresql_flexible_server block.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.postgresql.FlexibleServer;
import com.pulumi.azure.postgresql.FlexibleServerArgs;
import com.pulumi.azure.postgresql.FlexibleServerConfiguration;
import com.pulumi.azure.postgresql.FlexibleServerConfigurationArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("example-resources")
            .location("West Europe")
            .build());
        var exampleFlexibleServer = new FlexibleServer("exampleFlexibleServer", FlexibleServerArgs.builder()
            .name("example-psqlflexibleserver")
            .resourceGroupName(example.name())
            .location(example.location())
            .version("12")
            .administratorLogin("psqladmin")
            .administratorPassword("H@Sh1CoR3!")
            .storageMb(32768)
            .skuName("GP_Standard_D4s_v3")
            .build());
        var exampleFlexibleServerConfiguration = new FlexibleServerConfiguration("exampleFlexibleServerConfiguration", FlexibleServerConfigurationArgs.builder()
            .name("backslash_quote")
            .serverId(exampleFlexibleServer.id())
            .value("on")
            .build());
    }
}

Azure Extensions

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.postgresql.FlexibleServer;
import com.pulumi.azure.postgresql.FlexibleServerArgs;
import com.pulumi.azure.postgresql.FlexibleServerConfiguration;
import com.pulumi.azure.postgresql.FlexibleServerConfigurationArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("example-resources")
            .location("West Europe")
            .build());
        var exampleFlexibleServer = new FlexibleServer("exampleFlexibleServer", FlexibleServerArgs.builder()
            .name("example-psqlflexibleserver")
            .resourceGroupName(example.name())
            .location(example.location())
            .version("12")
            .administratorLogin("psqladmin")
            .administratorPassword("H@Sh1CoR3!")
            .storageMb(32768)
            .skuName("GP_Standard_D4s_v3")
            .build());
        var exampleFlexibleServerConfiguration = new FlexibleServerConfiguration("exampleFlexibleServerConfiguration", FlexibleServerConfigurationArgs.builder()
            .name("azure.extensions")
            .serverId(exampleFlexibleServer.id())
            .value("CUBE,CITEXT,BTREE_GIST")
            .build());
    }
}

Import

PostgreSQL Configurations can be imported using the resource id, e.g.

$ pulumi import azure:postgresql/flexibleServerConfiguration:FlexibleServerConfiguration example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/mygroup1/providers/Microsoft.DBforPostgreSQL/flexibleServers/server1/configurations/configuration1

Properties

val id: Output<String>

name

val name: Output<String>

Specifies the name of the PostgreSQL Configuration, which needs to be a valid PostgreSQL configuration name. Changing this forces a new resource to be created.

pulumiChildResources

val pulumiChildResources: Set<KotlinResource>

pulumiResourceName

val pulumiResourceName: String

pulumiResourceType

val pulumiResourceType: String

serverId

val serverId: Output<String>

The ID of the PostgreSQL Flexible Server where we want to change configuration. Changing this forces a new PostgreSQL Flexible Server Configuration resource.

urn

val urn: Output<String>

value

val value: Output<String>

Specifies the value of the PostgreSQL Configuration. See the PostgreSQL documentation for valid values.