If i have been deploying to dev this entire time and I now deploy to prod with a postgres database will an entirely new database be created?

Yes that's right each stage gets its own resources