Skip to content

Instantly share code, notes, and snippets.

@erickzanardo

erickzanardo/pg_tablespace.sql

Created February 4, 2016 17:32
Show Gist options
  • Save erickzanardo/6bd22c87abae4cf492a5 to your computer and use it in GitHub Desktop.
Save erickzanardo/6bd22c87abae4cf492a5 to your computer and use it in GitHub Desktop.
Download ZIP
PG tablespace
Raw
pg_tablespace.sql
# For many reason tablespace location should be on the partition root
sudo mkdir /root_of_fs/pgfoo
sudo chown postgres: /root_of_fs/pgfoo
CREATE TABLESPACE foo LOCATION '/root_of_fs/pgfoo';
ALTER DATABASE my_db TABLESPACE foo;
CREATE DATABASE my_db TABLESPACE foo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment