HEX
Server: Apache
System: Linux vps-cdc32557.vps.ovh.ca 5.15.0-156-generic #166-Ubuntu SMP Sat Aug 9 00:02:46 UTC 2025 x86_64
User: hanode (1017)
PHP: 7.4.33
Disabled: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
Upload Files
File: //usr/lib/python3/dist-packages/awscli/examples/lightsail/get-relational-databases.rst
**To get information about all relational databases**

The following ``get-relational-databases`` example displays details about all of the relational databases in the configured AWS Region. ::

    aws lightsail get-relational-databases

Output::

    {
        "relationalDatabases": [
            {
                "name": "MySQL",
                "arn": "arn:aws:lightsail:us-west-2:111122223333:RelationalDatabase/8529020c-3ab9-4d51-92af-5EXAMPLE8979",
                "supportCode": "6EXAMPLE3362/ls-3EXAMPLEa995d8c3b06b4501356e5f2f28e1aeba",
                "createdAt": 1554306019.155,
                "location": {
                    "availabilityZone": "us-west-2a",
                    "regionName": "us-west-2"
                },
                "resourceType": "RelationalDatabase",
                "tags": [],
                "relationalDatabaseBlueprintId": "mysql_8_0",
                "relationalDatabaseBundleId": "micro_1_0",
                "masterDatabaseName": "dbmaster",
                "hardware": {
                    "cpuCount": 1,
                    "diskSizeInGb": 40,
                    "ramSizeInGb": 1.0
                },
                "state": "available",
                "backupRetentionEnabled": true,
                "pendingModifiedValues": {},
                "engine": "mysql",
                "engineVersion": "8.0.15",
                "latestRestorableTime": 1571686200.0,
                "masterUsername": "dbmasteruser",
                "parameterApplyStatus": "in-sync",
                "preferredBackupWindow": "07:51-08:21",
                "preferredMaintenanceWindow": "tue:12:18-tue:12:48",
                "publiclyAccessible": true,
                "masterEndpoint": {
                    "port": 3306,
                    "address": "ls-3EXAMPLEa995d8c3b06b4501356e5f2fEXAMPLEa.czowadgeezqi.us-west-2.rds.amazonaws.com"
                },
                "pendingMaintenanceActions": []
            },
            {
                "name": "Postgres",
                "arn": "arn:aws:lightsail:us-west-2:111122223333:RelationalDatabase/e9780b6b-d0ab-4af2-85f1-1EXAMPLEac68",
                "supportCode": "6EXAMPLE3362/ls-3EXAMPLEb4fffb5cec056220c734713e14bd5fcd",
                "createdAt": 1554306000.814,
                "location": {
                    "availabilityZone": "us-west-2a",
                    "regionName": "us-west-2"
                },
                "resourceType": "RelationalDatabase",
                "tags": [],
                "relationalDatabaseBlueprintId": "postgres_11",
                "relationalDatabaseBundleId": "micro_1_0",
                "masterDatabaseName": "dbmaster",
                "hardware": {
                    "cpuCount": 1,
                    "diskSizeInGb": 40,
                    "ramSizeInGb": 1.0
                },
                "state": "available",
                "backupRetentionEnabled": true,
                "pendingModifiedValues": {},
                "engine": "postgres",
                "engineVersion": "11.1",
                "latestRestorableTime": 1571686339.0,
                "masterUsername": "dbmasteruser",
                "parameterApplyStatus": "in-sync",
                "preferredBackupWindow": "06:19-06:49",
                "preferredMaintenanceWindow": "sun:10:19-sun:10:49",
                "publiclyAccessible": false,
                "masterEndpoint": {
                    "port": 5432,
                    "address": "ls-3EXAMPLEb4fffb5cec056220c734713eEXAMPLEd.czowadgeezqi.us-west-2.rds.amazonaws.com"
                },
                "pendingMaintenanceActions": []
            }
        ]
    }