title: How to dis-connect and then re-connect a postgres tablespace?
body: <p>Is it possible to dis-connect and re-connect a <code>POSTGRES</code> tablespace and all the associated objects within that tablespace?</p>
  <p>I have a Postgres database with two tablespaces, one on a high-speed SSD drive (I've named this FASTSPACE) , and the other on a slower, traditional magnetic HDD (named SLOWSPACE). The slower tablespace is reserved for large volumes of historic data which is rarely accessed.</p>
  <p>Is it possible to temporarily disconnect <code>SLOWSPACE</code>, with the intention of reconnecting it at a later date? the <code>DROP TABLESPACE</code> documentation can only be used once all database objects within it have been dropped.</p>
  <p>I'm aware that I can backup all the tables in <code>SLOWSPACE</code>, then delete them, and then <code>DROP</code> the tablespace, however this will take time (there are several Terabytes of data). If I then need the archived data again I'll have create a new version of the <code>SLOWSPACE</code> tablespace from blank, then re-create all the objects from the backups. Again, this will take time.</p>
  <p>Is there any way of temporarily disconnecting <code>SLOWSPACE</code> from the database - whilst still leaving the rest of the database up and running?</p>
  <p>Update - happy to accept Franks Heikens two letter answer - 'no'</p>