AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
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 ?

주제
데이터베이스마이그레이션 및 현대화분석
태그
PostgreSQL아마존 Relational Database Service데이터베이스
언어
English
Ram Krishna
질문됨 4달 전584회 조회
1개 답변
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
전문가
Didier_Durand
답변함 4달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠