How To Create Tablespace On PostgreSQL

dbtut

6 years ago

We should need to create tablespace on postgresql sometimes.

I recommend to create a new tablespace when you create a database. Do not use default tablespace any time.

You can create tablespace with below command.

x	your tablespace name
testuser	who is the owner of the tablespace
/x/pg_data/	location of the tablespace

create tablespace x owner testuser location '/x/pg_data/';

1	create tablespace x owner testuser location '/x/pg_data/';