By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

postgresql.conf contains errors; unaffected changes were applied

0

I have a postgres RDS instance with db engine version 12.17, RDS instance db.m5.2xlarge. It is having temp file of 12TB, so I was modifying the DB instance parameter group, temp_file option. But when I save and db instance tries to apply, I see error in postgres error. saying following. rdsdbdata/config/postgresql.conf contains errors; unaffected changes were applied.

What to do ?

Topics
DatabaseMigration & ModernizationAnalytics
Tags
PostgreSQLAmazon Relational Database ServiceDatabase
Language
English
Ram Krishna
asked 3 months ago541 views
1 Answer
1

Hi

This means that out of all the config changes that you made, the valid ones (ie. unaffected by detected errors) were applied by Postgresql.

You may want to read and follow this post to fix your temp_files issue(s): https://klouddb.io/temporary-files-in-postgresql-steps-to-identify-and-fix-temp-file-issues/

You may also want to follow the AWS official documentation re. management of temp files in pg: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.ManagingTempFiles.html

Best,

Didier

profile pictureAWS
EXPERT
Didier_Durand
answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content