Table Space
CREATE TABLESPACE cbs LOCATION '/mnt/cbsvolume/pgdata';
To list table spaces:
postgres=# \db
List of tablespaces
Name | Owner | Location
------------+----------+-----------------------
cbs | postgres | /mnt/cbsvolume/pgdata
pg_default | postgres |
pg_global | postgres |
To show which database are on a table space:
postgres=# \l+
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace |
---------+----------+----------+---------+-------+-------------------+---------+------------+
csw_abc | csw_abc | UTF8 | C | C | | 6881 kB | pg_default |
csw_def | csw_def | UTF8 | C | C | | 6737 kB | pg_default |
csw_xyz | csw_xyz | UTF8 | C | C | | 5793 kB | cbs |