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

I assume your database is hosted in AWS RDS and not a database running from the same service (EC2, ECS) where the application is running?

Also, do you lose content, and users from the database? Is it like a fresh Strapi installation?