postgresql.conf contains errors; unaffected changes were applied

Question

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 ?

Answer

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

postgresql.conf contains errors; unaffected changes were applied

相關內容