CmdID

CmdID / aws / aws lightsail

aws lightsail get-relational-database-parameters

Returns all of the runtime parameters offered by the underlying database software, or engine, for a specific database in Amazon Lightsail. AWS CLI reference

1 example 2 options Its page in the AWS CLI reference

Opens CmdID with your command. It is read in your browser and sent nowhere.

Examples

from aws-cli, each command read by CmdID

To get parameters for a relational database

The following get-relational-database-parameters example returns information about all of the available parameters for the specified relational database.

aws lightsail get-relational-database-parameters --relational-database-name Database-1Identify
--relational-database-nameThe name of your database for which to get parameters.
Its output, shortened
{
    "parameters": [
        {
            "allowedValues": "0,1",
            "applyMethod": "pending-reboot",
            "applyType": "dynamic",
            "dataType": "boolean",
            "description": "Automatically set all granted roles as active after the user has authenticated successfully.",
            "isModifiable": true,
            "parameterName": "activate_all_roles_on_login",
            "parameterValue": "0"
        },
        {
            "allowedValues": "0,1",
            "applyMethod": "pending-reboot",
            "applyType": "static",
            "dataType": "boolean",
            "description": "Controls whether user-defined functions that have only an xxx symbol for the main function can be loaded",
            "isModifiable": false,
            "parameterName": "allow-suspicious-udfs"
        },
        {
            "allowedValues": "0,1",
            "applyMethod": "pending-reboot",
            "applyType": "dynamic",
            "dataType": "boolean",
            "description": "Sets the autocommit mode",
            "isModifiable": true,
            "parameterName": "autocommit"
        },
… 11 more lines

For more information, see Updating database parameters in Amazon Lightsail in the Lightsail Dev Guide.

Options

2 in the AWS CLI reference
--page-tokenThe token to advance to the next page of results from your request.
--relational-database-nameThe name of your database for which to get parameters.