Imagine a situation:
- I got a Postgres database working on single server on one of HDD partitions (partition size 100GB)
- Database grows up to 100GB taking whole free place on the partition
- Database stops working because of none free space on HDD
What do I need to do in situation when Postgres database will occupy 100% of partition that the database is on? Can I move the Postgres database into multiple HDD partitions which there will be similar amount of data on all of them?
If it's possible, how to do that?