How to make a partial copy of a postgres database?

Question

PostgreSQL

There is a postgres database in production, earlier for development, they either manually recreated the structure and filled it with fake data, or deployed a full copy.
But the process is underway, more and more tasks for testing and implementing new features appear, I would like to work with real data, and the database size of 500GB does not allow you to quickly make copies.
Are there any ways or tools to do a partial database dump?

Answer 1

Obviously, you need to somehow partition the data according to the desired attribute, thereby reducing the size, or create a small snapshot once and then apply the same changes to it as to production.
In general, it is strange that you have to recreate something for development - it usually happens the other way around, first innovations are rolled onto the development and test bases and only then on to production.