postgresql.UserMapping

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

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

import pulumi
import pulumi_postgresql as postgresql

ext_postgres_fdw = postgresql.Extension("ext_postgres_fdw", name="postgres_fdw")
myserver_postgres = postgresql.Server("myserver_postgres",
    server_name="myserver_postgres",
    fdw_name="postgres_fdw",
    options={
        "host": "foo",
        "dbname": "foodb",
        "port": "5432",
    },
    opts=pulumi.ResourceOptions(depends_on=[ext_postgres_fdw]))
remote = postgresql.Role("remote", name="remote")
remote_user_mapping = postgresql.UserMapping("remote",
    server_name=myserver_postgres.server_name,
    user_name=remote.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, "ext_postgres_fdw", &postgresql.ExtensionArgs{
			Name: pulumi.String("postgres_fdw"),
		})
		if err != nil {
			return err
		}
		myserverPostgres, err := postgresql.NewServer(ctx, "myserver_postgres", &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
		}
		remote, err := postgresql.NewRole(ctx, "remote", &postgresql.RoleArgs{
			Name: pulumi.String("remote"),
		})
		if err != nil {
			return err
		}
		_, err = postgresql.NewUserMapping(ctx, "remote", &postgresql.UserMappingArgs{
			ServerName: myserverPostgres.ServerName,
			UserName:   remote.Name,
			Options: pulumi.StringMap{
				"user":     pulumi.String("admin"),
				"password": pulumi.String("pass"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var extPostgresFdw = new PostgreSql.Extension("ext_postgres_fdw", new()
    {
        Name = "postgres_fdw",
    });

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

    var remote = new PostgreSql.Role("remote", new()
    {
        Name = "remote",
    });

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

});

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.ExtensionArgs;
import com.pulumi.postgresql.Server;
import com.pulumi.postgresql.ServerArgs;
import com.pulumi.postgresql.Role;
import com.pulumi.postgresql.RoleArgs;
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", ExtensionArgs.builder()        
            .name("postgres_fdw")
            .build());

        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 remote = new Role("remote", RoleArgs.builder()        
            .name("remote")
            .build());

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

    }
}

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

var userMappingResource = new PostgreSql.UserMapping("userMappingResource", new()
{
    ServerName = "string",
    UserName = "string",
    Options = 
    {
        { "string", "string" },
    },
});

example, err := postgresql.NewUserMapping(ctx, "userMappingResource", &postgresql.UserMappingArgs{
	ServerName: pulumi.String("string"),
	UserName:   pulumi.String("string"),
	Options: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
})

var userMappingResource = new UserMapping("userMappingResource", UserMappingArgs.builder()
    .serverName("string")
    .userName("string")
    .options(Map.of("string", "string"))
    .build());

user_mapping_resource = postgresql.UserMapping("userMappingResource",
    server_name="string",
    user_name="string",
    options={
        "string": "string",
    })

const userMappingResource = new postgresql.UserMapping("userMappingResource", {
    serverName: "string",
    userName: "string",
    options: {
        string: "string",
    },
});

type: postgresql:UserMapping
properties:
    options:
        string: string
    serverName: string
    userName: string