Data is lost after re-deploy, postgres database in develop and production

You’re not the first to make this mistake and I was going to assume this in my previous answer.

I think Strapi should be explicitly expecting this value to be provided. It shouldn’t assume it’s SQLite.

Glad you sorted it out.