postgresql.UserMapping

import * as pulumi from "@pulumi/pulumi";
import * as postgresql from "@pulumi/postgresql";

const extPostgresFdw = new postgresql.Extension("extPostgresFdw", {});
const myserverPostgres = new postgresql.Server("myserverPostgres", {
    serverName: "myserver_postgres",
    fdwName: "postgres_fdw",
    options: {
        host: "foo",
        dbname: "foodb",
        port: "5432",
    },
}, {
    dependsOn: [extPostgresFdw],
});
const remoteRole = new postgresql.Role("remoteRole", {});
const remoteUserMapping = new postgresql.UserMapping("remoteUserMapping", {
    serverName: myserverPostgres.serverName,
    userName: remoteRole.name,
    options: {
        user: "admin",
        password: "pass",
    },
});

import pulumi
import pulumi_postgresql as postgresql

ext_postgres_fdw = postgresql.Extension("extPostgresFdw")
myserver_postgres = postgresql.Server("myserverPostgres",
    server_name="myserver_postgres",
    fdw_name="postgres_fdw",
    options={
        "host": "foo",
        "dbname": "foodb",
        "port": "5432",
    },
    opts=pulumi.ResourceOptions(depends_on=[ext_postgres_fdw]))
remote_role = postgresql.Role("remoteRole")
remote_user_mapping = postgresql.UserMapping("remoteUserMapping",
    server_name=myserver_postgres.server_name,
    user_name=remote_role.name,
    options={
        "user": "admin",
        "password": "pass",
    })

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using PostgreSql = Pulumi.PostgreSql;

return await Deployment.RunAsync(() => 
{
    var extPostgresFdw = new PostgreSql.Extension("extPostgresFdw");

    var myserverPostgres = new PostgreSql.Server("myserverPostgres", new()
    {
        ServerName = "myserver_postgres",
        FdwName = "postgres_fdw",
        Options = 
        {
            { "host", "foo" },
            { "dbname", "foodb" },
            { "port", "5432" },
        },
    }, new CustomResourceOptions
    {
        DependsOn = new[]
        {
            extPostgresFdw,
        },
    });

    var remoteRole = new PostgreSql.Role("remoteRole");

    var remoteUserMapping = new PostgreSql.UserMapping("remoteUserMapping", new()
    {
        ServerName = myserverPostgres.ServerName,
        UserName = remoteRole.Name,
        Options = 
        {
            { "user", "admin" },
            { "password", "pass" },
        },
    });

});

package main

import (
	"github.com/pulumi/pulumi-postgresql/sdk/v3/go/postgresql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		extPostgresFdw, err := postgresql.NewExtension(ctx, "extPostgresFdw", nil)
		if err != nil {
			return err
		}
		myserverPostgres, err := postgresql.NewServer(ctx, "myserverPostgres", &postgresql.ServerArgs{
			ServerName: pulumi.String("myserver_postgres"),
			FdwName:    pulumi.String("postgres_fdw"),
			Options: pulumi.StringMap{
				"host":   pulumi.String("foo"),
				"dbname": pulumi.String("foodb"),
				"port":   pulumi.String("5432"),
			},
		}, pulumi.DependsOn([]pulumi.Resource{
			extPostgresFdw,
		}))
		if err != nil {
			return err
		}
		remoteRole, err := postgresql.NewRole(ctx, "remoteRole", nil)
		if err != nil {
			return err
		}
		_, err = postgresql.NewUserMapping(ctx, "remoteUserMapping", &postgresql.UserMappingArgs{
			ServerName: myserverPostgres.ServerName,
			UserName:   remoteRole.Name,
			Options: pulumi.StringMap{
				"user":     pulumi.String("admin"),
				"password": pulumi.String("pass"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.postgresql.Extension;
import com.pulumi.postgresql.Server;
import com.pulumi.postgresql.ServerArgs;
import com.pulumi.postgresql.Role;
import com.pulumi.postgresql.UserMapping;
import com.pulumi.postgresql.UserMappingArgs;
import com.pulumi.resources.CustomResourceOptions;
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 extPostgresFdw = new Extension("extPostgresFdw");

        var myserverPostgres = new Server("myserverPostgres", ServerArgs.builder()        
            .serverName("myserver_postgres")
            .fdwName("postgres_fdw")
            .options(Map.ofEntries(
                Map.entry("host", "foo"),
                Map.entry("dbname", "foodb"),
                Map.entry("port", "5432")
            ))
            .build(), CustomResourceOptions.builder()
                .dependsOn(extPostgresFdw)
                .build());

        var remoteRole = new Role("remoteRole");

        var remoteUserMapping = new UserMapping("remoteUserMapping", UserMappingArgs.builder()        
            .serverName(myserverPostgres.serverName())
            .userName(remoteRole.name())
            .options(Map.ofEntries(
                Map.entry("user", "admin"),
                Map.entry("password", "pass")
            ))
            .build());

    }
}

resources:
  extPostgresFdw:
    type: postgresql:Extension
  myserverPostgres:
    type: postgresql:Server
    properties:
      serverName: myserver_postgres
      fdwName: postgres_fdw
      options:
        host: foo
        dbname: foodb
        port: '5432'
    options:
      dependson:
        - ${extPostgresFdw}
  remoteRole:
    type: postgresql:Role
  remoteUserMapping:
    type: postgresql:UserMapping
    properties:
      serverName: ${myserverPostgres.serverName}
      userName: ${remoteRole.name}
      options:
        user: admin
        password: pass