Alt Text
Alt Text

How To Change RDS postgresql configurations

  • See the list of configurations that your RDS is using.
  • You can change these parameters. You can change those that are listed in the RDS reference page.
Alt Text
Alt Text
Alt Text
  • The RDS use Parameter group default.postgres10. A parameter group acts as a container for engine configuration values that are applied to one or more DB instances.
  • It’s not able to change parameters in the default parameter groups
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
Alt Text
  • The config require reboot
Alt Text
Alt Text
Alt Text
ubuntu@root:~$ psql -h mydb -p 5432 -U dbadmin_user -d mydatabase 
Password for user dbadmin_user:
psql (11.5 (Ubuntu 11.5-3.pgdg18.04+1), server 10.4)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

mydatabase=> show wal_level;
wal_level
-----------
logical
(1 row)

Awesome Devops || CloudOpz