I had the same problem. Does your Mac have Intel processor or Apple Silicon (M series)?

If you have Intel processor, you don't need to do anything. PostgreSQL should work fine, since it's built for Intel processors.

If you have Apple Silicon, e.g. M3, you need to install Rosetta. You can check this Reddit link if you need help.