Docs Home
selectel.DbaasPostgresqlDatabaseV1
Explore with Pulumi AI
Creates and manages a PostgreSQL database using public API v1. Applicable to PostgreSQL, PostgreSQL for 1C, and PostgreSQL TimescaleDB databases. The type is determined by the selectel.DbaasPostgresqlDatastoreV1 resource. For more information about Managed Databases, see the official Selectel documentation for PostgreSQL, PostgreSQL for 1C, and PostgreSQL TimescaleDB.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as selectel from "@pulumi/selectel";
const database1 = new selectel.DbaasPostgresqlDatabaseV1("database1", {
projectId: selectel_vpc_project_v2.project_1.id,
region: "ru-3",
datastoreId: selectel_dbaas_postgresql_datastore_v1.datastore_1.id,
ownerId: selectel_dbaas_user_v1.user_1.id,
});
import pulumi
import pulumi_selectel as selectel
database1 = selectel.DbaasPostgresqlDatabaseV1("database1",
project_id=selectel_vpc_project_v2["project_1"]["id"],
region="ru-3",
datastore_id=selectel_dbaas_postgresql_datastore_v1["datastore_1"]["id"],
owner_id=selectel_dbaas_user_v1["user_1"]["id"])
package main
import (
"github.com/pulumi/pulumi-terraform-provider/sdks/go/selectel/v6/selectel"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := selectel.NewDbaasPostgresqlDatabaseV1(ctx, "database1", &selectel.DbaasPostgresqlDatabaseV1Args{
ProjectId: pulumi.Any(selectel_vpc_project_v2.Project_1.Id),
Region: pulumi.String("ru-3"),
DatastoreId: pulumi.Any(selectel_dbaas_postgresql_datastore_v1.Datastore_1.Id),
OwnerId: pulumi.Any(selectel_dbaas_user_v1.User_1.Id),
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Selectel = Pulumi.Selectel;
return await Deployment.RunAsync(() =>
{
var database1 = new Selectel.DbaasPostgresqlDatabaseV1("database1", new()
{
ProjectId = selectel_vpc_project_v2.Project_1.Id,
Region = "ru-3",
DatastoreId = selectel_dbaas_postgresql_datastore_v1.Datastore_1.Id,
OwnerId = selectel_dbaas_user_v1.User_1.Id,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.selectel.DbaasPostgresqlDatabaseV1;
import com.pulumi.selectel.DbaasPostgresqlDatabaseV1Args;
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 database1 = new DbaasPostgresqlDatabaseV1("database1", DbaasPostgresqlDatabaseV1Args.builder()
.projectId(selectel_vpc_project_v2.project_1().id())
.region("ru-3")
.datastoreId(selectel_dbaas_postgresql_datastore_v1.datastore_1().id())
.ownerId(selectel_dbaas_user_v1.user_1().id())
.build());
}
}
resources:
database1:
type: selectel:DbaasPostgresqlDatabaseV1
properties:
projectId: ${selectel_vpc_project_v2.project_1.id}
region: ru-3
datastoreId: ${selectel_dbaas_postgresql_datastore_v1.datastore_1.id}
ownerId: ${selectel_dbaas_user_v1.user_1.id}
Create DbaasPostgresqlDatabaseV1 Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new DbaasPostgresqlDatabaseV1(name: string, args: DbaasPostgresqlDatabaseV1Args, opts?: CustomResourceOptions);@overload
def DbaasPostgresqlDatabaseV1(resource_name: str,
args: DbaasPostgresqlDatabaseV1Args,
opts: Optional[ResourceOptions] = None)
@overload
def DbaasPostgresqlDatabaseV1(resource_name: str,
opts: Optional[ResourceOptions] = None,
datastore_id: Optional[str] = None,
project_id: Optional[str] = None,
region: Optional[str] = None,
dbaas_postgresql_database_v1_id: Optional[str] = None,
lc_collate: Optional[str] = None,
lc_ctype: Optional[str] = None,
name: Optional[str] = None,
owner_id: Optional[str] = None,
timeouts: Optional[DbaasPostgresqlDatabaseV1TimeoutsArgs] = None)func NewDbaasPostgresqlDatabaseV1(ctx *Context, name string, args DbaasPostgresqlDatabaseV1Args, opts ...ResourceOption) (*DbaasPostgresqlDatabaseV1, error)public DbaasPostgresqlDatabaseV1(string name, DbaasPostgresqlDatabaseV1Args args, CustomResourceOptions? opts = null)
public DbaasPostgresqlDatabaseV1(String name, DbaasPostgresqlDatabaseV1Args args)
public DbaasPostgresqlDatabaseV1(String name, DbaasPostgresqlDatabaseV1Args args, CustomResourceOptions options)
type: selectel:DbaasPostgresqlDatabaseV1
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args DbaasPostgresqlDatabaseV1Args
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args DbaasPostgresqlDatabaseV1Args
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args DbaasPostgresqlDatabaseV1Args
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args DbaasPostgresqlDatabaseV1Args
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args DbaasPostgresqlDatabaseV1Args
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var dbaasPostgresqlDatabaseV1Resource = new Selectel.DbaasPostgresqlDatabaseV1("dbaasPostgresqlDatabaseV1Resource", new()
{
DatastoreId = "string",
ProjectId = "string",
Region = "string",
DbaasPostgresqlDatabaseV1Id = "string",
LcCollate = "string",
LcCtype = "string",
Name = "string",
OwnerId = "string",
Timeouts = new Selectel.Inputs.DbaasPostgresqlDatabaseV1TimeoutsArgs
{
Create = "string",
Delete = "string",
Update = "string",
},
});
example, err := selectel.NewDbaasPostgresqlDatabaseV1(ctx, "dbaasPostgresqlDatabaseV1Resource", &selectel.DbaasPostgresqlDatabaseV1Args{
DatastoreId: pulumi.String("string"),
ProjectId: pulumi.String("string"),
Region: pulumi.String("string"),
DbaasPostgresqlDatabaseV1Id: pulumi.String("string"),
LcCollate: pulumi.String("string"),
LcCtype: pulumi.String("string"),
Name: pulumi.String("string"),
OwnerId: pulumi.String("string"),
Timeouts: &selectel.DbaasPostgresqlDatabaseV1TimeoutsArgs{
Create: pulumi.String("string"),
Delete: pulumi.String("string"),
Update: pulumi.String("string"),
},
})
var dbaasPostgresqlDatabaseV1Resource = new DbaasPostgresqlDatabaseV1("dbaasPostgresqlDatabaseV1Resource", DbaasPostgresqlDatabaseV1Args.builder()
.datastoreId("string")
.projectId("string")
.region("string")
.dbaasPostgresqlDatabaseV1Id("string")
.lcCollate("string")
.lcCtype("string")
.name("string")
.ownerId("string")
.timeouts(DbaasPostgresqlDatabaseV1TimeoutsArgs.builder()
.create("string")
.delete("string")
.update("string")
.build())
.build());
dbaas_postgresql_database_v1_resource = selectel.DbaasPostgresqlDatabaseV1("dbaasPostgresqlDatabaseV1Resource",
datastore_id="string",
project_id="string",
region="string",
dbaas_postgresql_database_v1_id="string",
lc_collate="string",
lc_ctype="string",
name="string",
owner_id="string",
timeouts={
"create": "string",
"delete": "string",
"update": "string",
})
const dbaasPostgresqlDatabaseV1Resource = new selectel.DbaasPostgresqlDatabaseV1("dbaasPostgresqlDatabaseV1Resource", {
datastoreId: "string",
projectId: "string",
region: "string",
dbaasPostgresqlDatabaseV1Id: "string",
lcCollate: "string",
lcCtype: "string",
name: "string",
ownerId: "string",
timeouts: {
create: "string",
"delete": "string",
update: "string",
},
});
type: selectel:DbaasPostgresqlDatabaseV1
properties:
datastoreId: string
dbaasPostgresqlDatabaseV1Id: string
lcCollate: string
lcCtype: string
name: string
ownerId: string
projectId: string
region: string
timeouts:
create: string
delete: string
update: string
DbaasPostgresqlDatabaseV1 Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The DbaasPostgresqlDatabaseV1 resource accepts the following input properties:
- Datastore
Id string - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- Project
Id string - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- Region string
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - Dbaas
Postgresql stringDatabase V1Id - Lc
Collate string LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- Lc
Ctype string LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- Name string
- Database name. Changing this creates a new database.
- Owner
Id string - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- Timeouts
Dbaas
Postgresql Database V1Timeouts
- Datastore
Id string - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- Project
Id string - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- Region string
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - Dbaas
Postgresql stringDatabase V1Id - Lc
Collate string LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- Lc
Ctype string LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- Name string
- Database name. Changing this creates a new database.
- Owner
Id string - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- Timeouts
Dbaas
Postgresql Database V1Timeouts Args
- datastore
Id String - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- project
Id String - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region String
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - dbaas
Postgresql StringDatabase V1Id - lc
Collate String LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc
Ctype String LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name String
- Database name. Changing this creates a new database.
- owner
Id String - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- timeouts
Dbaas
Postgresql Database V1Timeouts
- datastore
Id string - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- project
Id string - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region string
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - dbaas
Postgresql stringDatabase V1Id - lc
Collate string LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc
Ctype string LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name string
- Database name. Changing this creates a new database.
- owner
Id string - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- timeouts
Dbaas
Postgresql Database V1Timeouts
- datastore_
id str - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- project_
id str - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region str
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - dbaas_
postgresql_ strdatabase_ v1_ id - lc_
collate str LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc_
ctype str LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name str
- Database name. Changing this creates a new database.
- owner_
id str - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- timeouts
Dbaas
Postgresql Database V1Timeouts Args
- datastore
Id String - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- project
Id String - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region String
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - dbaas
Postgresql StringDatabase V1Id - lc
Collate String LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc
Ctype String LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name String
- Database name. Changing this creates a new database.
- owner
Id String - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- timeouts Property Map
Outputs
All input properties are implicitly available as output properties. Additionally, the DbaasPostgresqlDatabaseV1 resource produces the following output properties:
Look up Existing DbaasPostgresqlDatabaseV1 Resource
Get an existing DbaasPostgresqlDatabaseV1 resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: DbaasPostgresqlDatabaseV1State, opts?: CustomResourceOptions): DbaasPostgresqlDatabaseV1@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
datastore_id: Optional[str] = None,
dbaas_postgresql_database_v1_id: Optional[str] = None,
lc_collate: Optional[str] = None,
lc_ctype: Optional[str] = None,
name: Optional[str] = None,
owner_id: Optional[str] = None,
project_id: Optional[str] = None,
region: Optional[str] = None,
status: Optional[str] = None,
timeouts: Optional[DbaasPostgresqlDatabaseV1TimeoutsArgs] = None) -> DbaasPostgresqlDatabaseV1func GetDbaasPostgresqlDatabaseV1(ctx *Context, name string, id IDInput, state *DbaasPostgresqlDatabaseV1State, opts ...ResourceOption) (*DbaasPostgresqlDatabaseV1, error)public static DbaasPostgresqlDatabaseV1 Get(string name, Input<string> id, DbaasPostgresqlDatabaseV1State? state, CustomResourceOptions? opts = null)public static DbaasPostgresqlDatabaseV1 get(String name, Output<String> id, DbaasPostgresqlDatabaseV1State state, CustomResourceOptions options)resources: _: type: selectel:DbaasPostgresqlDatabaseV1 get: id: ${id}- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Datastore
Id string - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- Dbaas
Postgresql stringDatabase V1Id - Lc
Collate string LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- Lc
Ctype string LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- Name string
- Database name. Changing this creates a new database.
- Owner
Id string - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- Project
Id string - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- Region string
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - Status string
- Database status.
- Timeouts
Dbaas
Postgresql Database V1Timeouts
- Datastore
Id string - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- Dbaas
Postgresql stringDatabase V1Id - Lc
Collate string LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- Lc
Ctype string LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- Name string
- Database name. Changing this creates a new database.
- Owner
Id string - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- Project
Id string - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- Region string
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - Status string
- Database status.
- Timeouts
Dbaas
Postgresql Database V1Timeouts Args
- datastore
Id String - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- dbaas
Postgresql StringDatabase V1Id - lc
Collate String LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc
Ctype String LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name String
- Database name. Changing this creates a new database.
- owner
Id String - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- project
Id String - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region String
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - status String
- Database status.
- timeouts
Dbaas
Postgresql Database V1Timeouts
- datastore
Id string - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- dbaas
Postgresql stringDatabase V1Id - lc
Collate string LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc
Ctype string LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name string
- Database name. Changing this creates a new database.
- owner
Id string - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- project
Id string - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region string
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - status string
- Database status.
- timeouts
Dbaas
Postgresql Database V1Timeouts
- datastore_
id str - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- dbaas_
postgresql_ strdatabase_ v1_ id - lc_
collate str LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc_
ctype str LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name str
- Database name. Changing this creates a new database.
- owner_
id str - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- project_
id str - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region str
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - status str
- Database status.
- timeouts
Dbaas
Postgresql Database V1Timeouts Args
- datastore
Id String - Unique identifier of the associated datastore. Changing this creates a new database. Retrieved from the selectel.DbaasMysqlDatastoreV1 resource.
- dbaas
Postgresql StringDatabase V1Id - lc
Collate String LC_COLLATE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_COLLATE field. The list of appropriate values is in the drop-down list.
- lc
Ctype String LC_CTYPE setting for the PostgreSQL datastore. Determined when you create a database and you cannot change it afterwards. The default value is
C.To get a list of available values, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ Create ⟶ the LC_CTYPE field. The list of appropriate values is in the drop-down list.
- name String
- Database name. Changing this creates a new database.
- owner
Id String - Unique identifier of the database owner. Retrieved from the selectel.DbaasUserV1 resource.
- project
Id String - Unique identifier of the associated project. Changing this creates a new database. Retrieved from the selectel.VpcProjectV2 resource. Learn more about Projects.
- region String
- Pool where the database is located, for example,
ru-3. Changing this creates a new database. Learn more about available pools in the Availability matrix. - status String
- Database status.
- timeouts Property Map
Supporting Types
DbaasPostgresqlDatabaseV1Timeouts, DbaasPostgresqlDatabaseV1TimeoutsArgs
Import
You can import a database:
export OS_DOMAIN_NAME=<account_id>
export OS_USERNAME=
export OS_PASSWORD=
export INFRA_PROJECT_ID=<selectel_project_id>
export INFRA_REGION=<selectel_pool>
$ pulumi import selectel:index/dbaasPostgresqlDatabaseV1:DbaasPostgresqlDatabaseV1 database_1 <database_id>
where:
<account_id>— Selectel account ID. The account ID is in the top right corner of the Control panel. Learn more about Registration.<username>— Name of the service user. To get the name, in the Control panel, go to Identity & Access Management ⟶ User management ⟶ the Service users tab ⟶ copy the name of the required user. Learn more about Service users.<password>— Password of the service user.<selectel_project_id>— Unique identifier of the associated project. To get the ID, in the Control panel, go to Cloud Platform ⟶ project name ⟶ copy the ID of the required project. Learn more about Projects.<selectel_pool>— Pool where the cluster is located, for example,ru-3. To get information about the pool, in the Control panel, go to Cloud Platform ⟶ Managed Databases. The pool is in the Pool column.<database_id>— Unique identifier of the database, for example,b311ce58-2658-46b5-b733-7a0f418703f2. To get the database ID, in the Control panel, go to Cloud Platform ⟶ Managed Databases ⟶ the cluster page ⟶ the Databases tab ⟶ copy the ID under the database name.
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- selectel selectel/terraform-provider-selectel
- License
- Notes
- This Pulumi package is based on the
selectelTerraform Provider.