Large pg_wal folder in Portal

[RichardSuematsu]

On Portal 10.8, my pg_wal folder (/opt/arcgis/portal/usr/arcgisportal/db/pg_wal) is running about 147GB.  This question/solution (https://community.esri.com/t5/arcgis-enterprise-questions/quot-wal-files-size-exceeded-the-max-size-...) suggests running the DR to clean it up.  For various reasons, that's problematic for me right now.  It also suggests there's a way to clean it up manually.  How is that done?  That folder seems to be filled with 9300+ files of 16m in size.  Do I just delete the files themselves?

Edit: Found these errors in the log files

2022-07-05 00:01:51 PDT: [4884]: FATAL: no pg_hba.conf entry for host "[local]", user "ags", database "ags", SSL off
2022-07-05 00:02:02 PDT: [2779]: LOG: archive command failed with exit code 1
2022-07-05 00:02:02 PDT: [2779]: DETAIL: The failed archive command was: test ! -f /opt/arcgis/portal/usr/arcgisportal/backup/walarchive/0000000200000050000000D6 && cp pg_wal/0000000200000050000000D6 /opt/arcgis/portal/usr/arcgisportal/backup/walarchive/0000000200000050000000D6

[ArnaudDessy1]

Hello @RichardSuematsu,

Did you manage to find a solution?

I would be keen to hear what you did.

Regards,
Arnaud

[RichardSuematsu]

Hey,

The problem was the environment I was in was very restricted and I couldn't get a shared drive on all the machines that's required for Webgisdr.  Eventually, I fixed that and ran webgisdr which greatly reduced the size of the walarchive folder.

[drunneals_cgs]

Just ran webgisdr and while it didn't immediately completely reduce the size (I'm assuming that pg has a post webgisdr compress), it did end up going from 108gb to 81mb