Associating a DB cluster parameter group with a DB cluster in Amazon Aurora
You can create your own DB cluster parameter groups with customized settings. You can associate a DB cluster parameter group with a DB cluster using the AWS Management Console, the AWS CLI, or the RDS API. You can do so when you create or modify a DB cluster.
For information about creating a DB cluster parameter group, see Creating a DB cluster parameter group in Amazon Aurora. For information about creating a DB cluster, see Creating an Amazon Aurora DB cluster. For information about modifying a DB cluster, see Modifying an Amazon Aurora DB cluster.
Note
For Aurora PostgreSQL 15.2, 14.7, 13.10, 12.14, and all 11 versions, when you change the DB cluster parameter group associated with a DB cluster, reboot each replica instance to apply the changes.
To determine whether the primary DB instance of a DB cluster must be rebooted to apply changes, run the following AWS CLI command:
aws rds describe-db-clusters --db-cluster-identifier
db_cluster_identifier
Check the DBClusterParameterGroupStatus
value for the primary DB instance in the output. If the value is pending-reboot
,
then reboot the primary DB instance of the DB cluster.
To associate a DB cluster parameter group with a DB cluster
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/
. -
In the navigation pane, choose Databases, and then select the DB cluster that you want to modify.
-
Choose Modify. The Modify DB cluster page appears.
-
Change the DB cluster parameter group setting.
-
Choose Continue and check the summary of modifications.
The change is applied immediately regardless of the Scheduling of modifications setting.
-
On the confirmation page, review your changes. If they are correct, choose Modify cluster to save your changes.
Alternatively, choose Back to edit your changes, or choose Cancel to cancel your changes.
To associate a DB cluster parameter group with a DB cluster, use the AWS CLI modify-db-cluster
command with the following options:
-
--db-cluster-name
-
--db-cluster-parameter-group-name
The following example associates the mydbclpg
DB parameter group with the
mydbcluster
DB cluster.
Example
For Linux, macOS, or Unix:
aws rds modify-db-cluster \ --db-cluster-identifier
mydbcluster
\ --db-cluster-parameter-group-namemydbclpg
For Windows:
aws rds modify-db-cluster ^ --db-cluster-identifier
mydbcluster
^ --db-cluster-parameter-group-namemydbclpg
To associate a DB cluster parameter group with a DB cluster, use the RDS API ModifyDBCluster
operation with the following parameters:
-
DBClusterIdentifier
-
DBClusterParameterGroupName