DBA Hub

📋Steps in this guide1/1

create/drop/rename tablespace in postgres

CREATE TABLESPACE: postgres=# create tablespace ts_postgres location '/Library/PostgreSQL/TEST/TS_POSTGRES'; CREATE TABLESPACE

postgresql configurationintermediate
by PostgreSQL
17 views
1

create/drop/rename tablespace in postgres

CREATE TABLESPACE: postgres=# create tablespace ts_postgres location '/Library/PostgreSQL/TEST/TS_POSTGRES'; CREATE TABLESPACE RENAME TABLESPACE: postgres=# alter tablespace ts_postgres rename to ts_dbaclass; ALTER TABLESPACE DROP TABLESPACE:

Code/Command (click line numbers to comment):

1
2
3
4
postgres=#
drop tablespace ts_dbaclass;
DROP TABLESPACE
<<Before dropping tablespace make sure it is emptry>>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!