Hi there,
I am running into an issue with the number of files that reside on the
pg_xlog directory of my compliance database server (This one is the
master server in our master-slave setup). Sometime earlier this year, I modified the location of the PITR directory and that caused an
issue with WAL segments not being sent to the correct location and
crashing the DB. I went ahead and fixed that up so that it
points to the correct location but since then the number of files on
the pg_xlog directory went up from around 898 to 1025. I didn't have a
chance to look in to this issue until now so my question is do you know
if there is an easy way to clean up some of these files in the pg_xlog
directory safely? I believe that there might be some orphaned files
there and would like to clean those up.
Also, on the Standby, the pg_xlog directory appears like it is growing on a daily basis. The WAL files are being cleaned up but I don't believe at a fast enough rate. This directory is approximately over 650GB in size and I would like to revisit if any of the parameters will need to be changed in the postgresql.conf file since it's almost 5 years since I last touched this.
Let me know if you need more details to clarify.
Also, on the Standby, the pg_xlog directory appears like it is growing on a daily basis. The WAL files are being cleaned up but I don't believe at a fast enough rate. This directory is approximately over 650GB in size and I would like to revisit if any of the parameters will need to be changed in the postgresql.conf file since it's almost 5 years since I last touched this.
Let me know if you need more details to clarify.
Thanks.
