We have about 200+ postgres 12.17 enterprise databases from AWS RDS registered in the multi-machine AGS site. While running the validate all from the server manager, it validates a few databases, some fails to validate, but most of the DBs at the end of the list fail to validate. If you go and check the db in smaller chunks (say 10-15) it validates fine.
I have already updated the Publishing tool instances and the javaheapmemory for this GP and still no luck. Any thoughts from the community?
Forgot to mention, that running the validate all on these 200 dbs, brings down the entire server sometimes.