Postgresql single base on multiple HDD partitions 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?
I would go for:

   CREATE TABLESPACE any_name LOCATION '/any_empty_dir';
   ALTER TABLE any_tables SET TABLESPACE any_name;


you can do this for a couple of tables to move them to a different filesystem.
it should be pretty easy to do.

you can also put entire databases on to different filesystems.