Alt Text
Alt Text

How To Change RDS postgresql configurations

- With RDS you don’t edit config files directly. Instead edit the parameters through the RDS console, or via the API.

- As of now, RDS does allow changing configurations. So you can

  • 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.

- This post give an example of change wal_level from replica to logical

What’s In This Document

🚀 General RDS configruation

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

🚀 Change RDS configruation

1. Create new parameter group

Alt Text
Alt Text

2. Set wal_level from replica to logical

Alt Text
Alt Text

3. Modify db instance to apply new parameter group

Alt Text
Alt Text
  • The config require reboot
Alt Text
Alt Text

🚀 Check wal_level

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)

Visit wwww.cloudopz.co to get more

🌠 Blog · Web · Linkedin · Group · Page · Twitter 🌠

--

--

--

Awesome Devops || CloudOpz

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Why Napkin?

Refresh: Lightweight Functional JDBC in Kotlin

AR/VR Today Episode #5: Development Special

Basic AWS Data Transfer Cost Saving Tips for Beginners

My 3rd DSA lab

On DevOps — 14. Puppet, Chef, Salt, Ansible, and Configuration Management Best Practice

iOS Coordinator

Three stages to make your Quality Assurance perfect… Almost perfect

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vu Dao

Vu Dao

Awesome Devops || CloudOpz

More from Medium

Question: What do you get when you combine flask API implementation of an ML model web app on the…

Abacus Tutorials | Lesson — Formula In Abacus Combination | Abacus Classes

CS 373 Spring 2022: Carlos Vela: Final Entry

Assert Functions in Unittest