Strapi 4.0.0 deleting Postgres db column which was added to a table manually

System Information
  • Strapi Version: 4.0.0
  • Operating System: MAC
  • Database: Postgres
  • Node Version: v16.13.1
  • NPM Version: 8.1.2
  • Yarn Version:


I added a db column to a table in Postgres manually cause the (geolocation geography(point)) was not available to be added from content builder. The field is not available in schema.json file.
On new deployment, the column get deleted by strapi. Any reason why ?
Strapi 4.0 would delete column from the DB if it’s not part of schema.json. Is there any way to prevent this from happening ?

@Vivek_Narayan Having a similar issue. Did you find a solution?

in database config, set