Hi Diny, Hope you are doing good. You can use pg_archivecleanup to resolve this issue. pg_archivecleanup is designed to be used as an archive_cleanup_command to clean up WAL file archives when running as a standby server. You can configure this in the recovery.conf file. Please refer the below link for more information regarding this: https://www.enterprisedb.com/docs/en/9.6/pg/pgarchivecleanup.html Let us know in case of any concern.
... View more
@Diny2019 wrote: but testing server again its happend the same issue..not only this postgresql..some other database like mongoDB also..same...what actully i need to do..in my sudo part... My efm user expired few months back..i suggest to reset of unix os user efm password.but my GM told last month also we did in patch..no issue happend in prod and uat...why we reset the password... Please suggest what i do in my sudo part..or anything someother part's? I don't know offhand what the solution is. It depends on how your system has sudo set up. My guess is you've run into this, which will affect anything that needs to run sudo: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/7.6_release_notes/new_features_security When we tried upgrading the OS we didn't see the problem -- something your the PAM configuration is affected. FWIW, when trying to debug it, you don't actually need to run efm. As the efm user, run something like: sudo <efminstall>/bin/efm_root_functions readnodes <clustername> Cheers, Bobby
... View more