Are you able to run the workflow in test mode without errors?
This could likely to be due to a mismatch in versioning. The Postgress node has been slightly updated in v.1.56.0 - Release [email protected] · n8n-io/n8n · GitHub - Could you replace the Portgress nodes for their latest version and let us know the outcome?
You can do this simply by removing the current nodes and adding setting them up again.
I am having the same issues. Had a workflow active and running, but stopped. It tests fine, completes, etc. I deactivated each node at a time to test, but nothing has worked. I can not activate it and it gets the same error you are getting.
EDIT: Of course, as soon as I post this I try something that worked - I deleted the trigger node and re-entered it. Now it can be activated.