How To Create Tablespace On PostgreSQL


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

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *