It's quite simple to do the exact same thing with postgres, you just configure a separate connection string for prod vs local deployments.