Why Can’t I Find and Set the Parameters logical_replication
and wal_sender_timeout
Using the Command-Line Interface (CLI)?
Question
While enabling incremental updates by following step 7 of the Amazon Aurora PostgreSQL setup guide, I need to set the parameters logical_replication
and wal_sender_timeout
, but the parameters are unavailable. Why can't I find and set either parameter using the Command-Line Interface (CLI)?
Environment
Connector: Amazon Aurora PostgreSQL
Answer
The logical_replication
and wal_sender_timeout
parameters are cluster-level parameters. Therefore, you must adjust these parameters at the cluster level rather than the instance level.
To manage cluster-level parameters in an AWS DB cluster parameter group using the CLI, use the AWS modify-db-cluster-parameter-group
CLI command. See AWS' modify-db-cluster-parameter-group documentation for more information.