# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
psql_client = OCI::Psql::PostgresqlClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
update_db_system_response =
psql_client.update_db_system(
'ocid1.test.oc1..<unique_ID>EXAMPLE-dbSystemId-Value',
OCI::Psql::Models::UpdateDbSystemDetails.new(
display_name: 'EXAMPLE-displayName-Value',
description: 'EXAMPLE-description-Value',
shape: 'EXAMPLE-shape-Value',
instance_ocpu_count: 667,
instance_memory_size_in_gbs: 875,
db_configuration_params:
OCI::Psql::Models::UpdateDbConfigParams.new(
config_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-configId-Value',
apply_config: 'RELOAD'
),
management_policy:
OCI::Psql::Models::ManagementPolicyDetails.new(
maintenance_window_start: 'EXAMPLE-maintenanceWindowStart-Value',
backup_policy:
OCI::Psql::Models::WeeklyBackupPolicy.new(
kind: 'WEEKLY',
days_of_the_week: %w[SUNDAY],
backup_start: 'EXAMPLE-backupStart-Value',
retention_days: 15,
copy_policy:
OCI::Psql::Models::BackupCopyPolicy.new(
compartment_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
retention_period: 979,
regions: %w[EXAMPLE--Value]
)
),
pitr_policy: OCI::Psql::Models::NonePitrPolicy.new(kind: 'NONE')
),
storage_details:
OCI::Psql::Models::UpdateStorageDetailsParams.new(iops: 144),
replication_config:
OCI::Psql::Models::UpdateReplicationConfigDetails.new(
is_rpo_enforced: true, rpo_in_seconds: 713
),
network_details:
OCI::Psql::Models::UpdateNetworkDetails.new(
nsg_ids: %w[EXAMPLE--Value], is_reader_endpoint_enabled: true
),
kerberos_auth_details:
OCI::Psql::Models::EnabledKerberosAuthDetails.new(
kind: 'ENABLED',
credentials: [
OCI::Psql::Models::KerberosCredential.new(
realm_name: 'EXAMPLE-realmName-Value',
keytab_secret_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-keytabSecretId-Value',
keytab_secret_version: 330
)
]
),
odsp_insight_details:
OCI::Psql::Models::EnabledInsightDetails.new(
kind: 'ENABLED',
odsp_insight_list: [
OCI::Psql::Models::OdspInsight.new(
insight_type: 'QUERY_INSIGHT', retention_period_in_days: 7
)
]
),
freeform_tags: {
'EXAMPLE_KEY_EExI9' => 'EXAMPLE_VALUE_xagsH8rfBcobLC5C62ri'
},
defined_tags: {
'EXAMPLE_KEY_CFLew' => { 'EXAMPLE_KEY_8O5OO' => 'EXAMPLE--Value' }
}
)
)
# Get the data from response
puts "#{update_db_system_response.headers}"