But with multiple parties involved, who has the rights to read and write to the postgres instance? How do we make sure transactions were not forged? How do we know data at rest is not being tampered with?

Blockchain solves that. Newer blockchain protocols especially an L1 is much faster, easier on the environment, and provides all the immutability, transparency, and traceability benefits.