Large pg_wal folder in Portal

102
0
07-05-2022 12:18 AM
RichardSuematsu
New Contributor II

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

0 Kudos
0 Replies