Using azure postgresql with search

Question

Pulumi · Accepted Answer

To use Azure PostgreSQL in combination with full-text search capabilities, you can provision an Azure Database for PostgreSQL server and configure it accordingly. Azure Database for PostgreSQL supports full-text search natively through PostgreSQL's text search features.

In this program, we will:

1. Create an Azure Resource Group, which is a container that holds related resources for an Azure solution.
2. Provision an Azure Database for PostgreSQL server within this resource group.
3. Configure the PostgreSQL server with appropriate parameters such as version, compute and storage resources, and location.
4. Set up a database within the PostgreSQL server where you can later configure full-text search indices and queries according to your use case.

Please make sure you have Pulumi installed and configured for use with Azure, and the required permissions to create resources in your Azure subscription.

Here's how you can create an Azure Database for PostgreSQL server using Pulumi and TypeScript:

```typescript
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

// Define configuration for our PostgreSQL server
const config = new pulumi.Config();
const postgresUsername = config.require("postgresUsername");
const postgresPassword = config.requireSecret("postgresPassword");
const location = config.get("location") || "WestUS";

// Create an Azure Resource Group
const resourceGroup = new azure_native.resources.ResourceGroup("myResourceGroup", {
    location: location,
});

// Create an Azure Database for PostgreSQL server
const postgresServer = new azure_native.dbforpostgresql.Server("myPostgresServer", {
    resourceGroupName: resourceGroup.name,
    location: resourceGroup.location,
    sku: {
        name: "B_Gen5_2",
        tier: "Basic",
        capacity: 2,
        family: "Gen5",
    },
    properties: {
        version: "11",
        administratorLogin: postgresUsername,
        administratorLoginPassword: postgresPassword,
        storageProfile: {
            storageMB: 51200, // Configure the storage size (50 GB)
        },
        sslEnforcement: "Enabled",
    },
});

// Create a database within the PostgreSQL server
const database = new azure_native.dbforpostgresql.Database("myDatabase", {
    resourceGroupName: resourceGroup.name,
    serverName: postgresServer.name,
    charset: "UTF8",
    collation: "English_United States.1252",
});

// Export the resulting base URL of the PostgreSQL server
export const postgresServerUrl = pulumi.all([postgresServer.name, resourceGroup.name]).apply(([serverName, rgName]) => `postgresql://${serverName}.postgres.database.azure.com:5432/${database.name}?sslmode=require`);

```

**Explanation:**

- We start by importing the required Pulumi packages.
- Configuration settings such as the PostgreSQL server's credentials and location are obtained through `pulumi.Config`.
- An Azure Resource Group is created using `azure_native.resources.ResourceGroup`.
- We define a new PostgreSQL server using `azure_native.dbforpostgresql.Server`, setting the SKU (Pricing tier and compute size), version, administrator login credentials, and storage profile.
- Then, inside our PostgreSQL server, a database is created with `azure_native.dbforpostgresql.Database`, where you can specify character set and collation as required.
- At the end of the program, we export the PostgreSQL server URL, which will be needed to connect to the database.

You can run this program with Pulumi by saving it to a file named `index.ts` and running `pulumi up`. Please replace the placeholder values in `config.require` with actual usernames and passwords.

Once the PostgreSQL server is set up, you can connect to it using any PostgreSQL client with the provided URL and configure the appropriate full-text search settings in your chosen database schema. Please refer to the [Azure Database for PostgreSQL documentation](https://docs.microsoft.com/en-us/azure/postgresql/) and the [PostgreSQL text search documentation](https://www.postgresql.org/docs/current/textsearch.html) for details on setting up and using full-text search.