Linode
getDatabasePostgresql
Provides information about a Linode PostgreSQL Database.
Attributes
The linode.DatabasePostgresql
data source exports the following attributes:
allow_list
- A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format.ca_cert
- The base64-encoded SSL CA certificate for the Managed Database instance.cluster_size
- The number of Linode Instance nodes deployed to the Managed Database.created
- When this Managed Database was created.encrypted
- Whether the Managed Databases is encrypted.engine
- The Managed Database engine. (e.g.postgresql
)engine_id
- The Managed Database engine in engine/version format. (e.g.postgresql/13.2
)host_primary
- The primary host for the Managed Database.host_secondary
- The secondary/private network host for the Managed Database.label
- A unique, user-defined string referring to the Managed Database.region
- The region that hosts this Linode Managed Database.root_password
- The randomly-generated root password for the Managed Database instance.root_username
- The root username for the Managed Database instance.replication_type
- The replication method used for the Managed Database. (none
,asynch
,semi_synch
)replication_commit_type
- (Optional) The synchronization level of the replicating server. (on
,local
,remote_write
,remote_apply
,off
)ssl_connection
- Whether to require SSL credentials to establish a connection to the Managed Database.status
- The operating status of the Managed Database.type
- The Linode Instance type used for the nodes of the Managed Database instance.updated
- When this Managed Database was last updated.updates
- (Optional) Configuration settings for automated patch update maintenance for the Managed Database.version
- The Managed Database engine version. (e.g.v8.0.26
)
updates
The following arguments are exported by the updates
specification block:
day_of_week
- The day to perform maintenance. (monday
,tuesday
, …)duration
- The maximum maintenance window time in hours. (1
..3
)frequency
- Whether maintenance occurs on a weekly or monthly basis. (weekly
,monthly
)hour_of_day
- The hour to begin maintenance based in UTC time. (0
..23
)week_of_month
- The week of the month to perform monthly frequency updates. Required formonthly
frequency updates. (1
..4
)
Example Usage
using Pulumi;
using Linode = Pulumi.Linode;
class MyStack : Stack
{
public MyStack()
{
var my_db = Output.Create(Linode.GetDatabasePostgresql.InvokeAsync(new Linode.GetDatabasePostgresqlArgs
{
DatabaseId = 12345,
}));
}
}
package main
import (
"github.com/pulumi/pulumi-linode/sdk/v3/go/linode"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := linode.LookupDatabasePostgresql(ctx, &GetDatabasePostgresqlArgs{
DatabaseId: 12345,
}, nil)
if err != nil {
return err
}
return nil
})
}
package generated_program;
import java.util.*;
import java.io.*;
import java.nio.*;
import com.pulumi.*;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var my-db = Output.of(LinodeFunctions.getDatabasePostgresql(GetDatabasePostgresqlArgs.builder()
.databaseId(12345)
.build()));
}
}
import pulumi
import pulumi_linode as linode
my_db = linode.get_database_postgresql(database_id=12345)
import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";
const my_db = pulumi.output(linode.getDatabasePostgresql({
databaseId: 12345,
}));
variables:
my-db:
Fn::Invoke:
Function: linode:getDatabasePostgresql
Arguments:
databaseId: 12345
Using getDatabasePostgresql
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getDatabasePostgresql(args: GetDatabasePostgresqlArgs, opts?: InvokeOptions): Promise<GetDatabasePostgresqlResult>
function getDatabasePostgresqlOutput(args: GetDatabasePostgresqlOutputArgs, opts?: InvokeOptions): Output<GetDatabasePostgresqlResult>
def get_database_postgresql(database_id: Optional[int] = None,
opts: Optional[InvokeOptions] = None) -> GetDatabasePostgresqlResult
def get_database_postgresql_output(database_id: Optional[pulumi.Input[int]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetDatabasePostgresqlResult]
func LookupDatabasePostgresql(ctx *Context, args *LookupDatabasePostgresqlArgs, opts ...InvokeOption) (*LookupDatabasePostgresqlResult, error)
func LookupDatabasePostgresqlOutput(ctx *Context, args *LookupDatabasePostgresqlOutputArgs, opts ...InvokeOption) LookupDatabasePostgresqlResultOutput
> Note: This function is named LookupDatabasePostgresql
in the Go SDK.
public static class GetDatabasePostgresql
{
public static Task<GetDatabasePostgresqlResult> InvokeAsync(GetDatabasePostgresqlArgs args, InvokeOptions? opts = null)
public static Output<GetDatabasePostgresqlResult> Invoke(GetDatabasePostgresqlInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabasePostgresqlResult> getDatabasePostgresql(GetDatabasePostgresqlArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
Function: linode:index/getDatabasePostgresql:getDatabasePostgresql
Arguments:
# Arguments dictionary
The following arguments are supported:
- Database
Id int The ID of the PostgreSQL database.
- Database
Id int The ID of the PostgreSQL database.
- database
Id Integer The ID of the PostgreSQL database.
- database
Id number The ID of the PostgreSQL database.
- database_
id int The ID of the PostgreSQL database.
- database
Id Number The ID of the PostgreSQL database.
getDatabasePostgresql Result
The following output properties are available:
- Allow
Lists List<string> - Ca
Cert string - Cluster
Size int - Created string
- Database
Id int - Encrypted bool
- Engine string
- Engine
Id string - Host
Primary string - Host
Secondary string - Id string
The provider-assigned unique ID for this managed resource.
- Label string
- Port int
- Region string
- Replication
Commit stringType - Replication
Type string - Root
Password string - Root
Username string - Ssl
Connection bool - Status string
- Type string
- Updated string
- Updates
List<Get
Database Postgresql Update> - Version string
- Allow
Lists []string - Ca
Cert string - Cluster
Size int - Created string
- Database
Id int - Encrypted bool
- Engine string
- Engine
Id string - Host
Primary string - Host
Secondary string - Id string
The provider-assigned unique ID for this managed resource.
- Label string
- Port int
- Region string
- Replication
Commit stringType - Replication
Type string - Root
Password string - Root
Username string - Ssl
Connection bool - Status string
- Type string
- Updated string
- Updates
[]Get
Database Postgresql Update - Version string
- allow
Lists List<String> - ca
Cert String - cluster
Size Integer - created String
- database
Id Integer - encrypted Boolean
- engine String
- engine
Id String - host
Primary String - host
Secondary String - id String
The provider-assigned unique ID for this managed resource.
- label String
- port Integer
- region String
- replication
Commit StringType - replication
Type String - root
Password String - root
Username String - ssl
Connection Boolean - status String
- type String
- updated String
- updates
List<Get
Database Postgresql Update> - version String
- allow
Lists string[] - ca
Cert string - cluster
Size number - created string
- database
Id number - encrypted boolean
- engine string
- engine
Id string - host
Primary string - host
Secondary string - id string
The provider-assigned unique ID for this managed resource.
- label string
- port number
- region string
- replication
Commit stringType - replication
Type string - root
Password string - root
Username string - ssl
Connection boolean - status string
- type string
- updated string
- updates
Get
Database Postgresql Update[] - version string
- allow_
lists Sequence[str] - ca_
cert str - cluster_
size int - created str
- database_
id int - encrypted bool
- engine str
- engine_
id str - host_
primary str - host_
secondary str - id str
The provider-assigned unique ID for this managed resource.
- label str
- port int
- region str
- replication_
commit_ strtype - replication_
type str - root_
password str - root_
username str - ssl_
connection bool - status str
- type str
- updated str
- updates
Sequence[Get
Database Postgresql Update] - version str
- allow
Lists List<String> - ca
Cert String - cluster
Size Number - created String
- database
Id Number - encrypted Boolean
- engine String
- engine
Id String - host
Primary String - host
Secondary String - id String
The provider-assigned unique ID for this managed resource.
- label String
- port Number
- region String
- replication
Commit StringType - replication
Type String - root
Password String - root
Username String - ssl
Connection Boolean - status String
- type String
- updated String
- updates List<Property Map>
- version String
Supporting Types
GetDatabasePostgresqlUpdate
- Day
Of stringWeek - Duration int
- Frequency string
- Hour
Of intDay - Week
Of intMonth
- Day
Of stringWeek - Duration int
- Frequency string
- Hour
Of intDay - Week
Of intMonth
- day
Of StringWeek - duration Integer
- frequency String
- hour
Of IntegerDay - week
Of IntegerMonth
- day
Of stringWeek - duration number
- frequency string
- hour
Of numberDay - week
Of numberMonth
- day_
of_ strweek - duration int
- frequency str
- hour_
of_ intday - week_
of_ intmonth
- day
Of StringWeek - duration Number
- frequency String
- hour
Of NumberDay - week
Of NumberMonth
Package Details
- Repository
- https://github.com/pulumi/pulumi-linode
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
linode
Terraform Provider.