Rando
Rando

Reputation: 55

How to specify tablespace when creating postgres database?

My postgres server is running out of space when restoring database, after dumping, How can I create a tablespace and specify a new database to that specific location.

Some examples would be nice. Thanks

Upvotes: 1

Views: 123

Answers (1)

Anton Kim
Anton Kim

Reputation: 953

PostgreSQL CREATE TABLESPACE statement

create database dbname with tablespace = tablespace_name;

Upvotes: 3

Related Questions