From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
---|---|
To: | AI Rumman <rummandba(at)gmail(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: location for pg_default tablespace |
Date: | 2010-01-12 05:50:11 |
Message-ID: | 4B4C0D93.30005@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
AI Rumman wrote:
> But actually I want to know that why the value in spclocation is null
> is pg_tablespace for pg_default.
> Moreover, $PGDATA/pg_tblspc has no file.
> Could you please tell me why?
PostgreSQL ships with a blank tablespace setting, which it interprets as
meaning you want to put the database table files into the default
tablespace which is stored in $PGDATA/base
When you create a new tablespace using CREATE TABLESPACE:
http://www.postgresql.org/docs/current/static/sql-createtablespace.html
Then you'll find that pg_tblspc contains a symbolic link to the new
directory you've told it to use. At that point, you can then point all
new creation toward that location by setting default_tablespace, or put
individual bits of data onto there with the appropriate options to
CREATE:
http://www.postgresql.org/docs/current/static/manage-ag-tablespaces.html
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian von Bidder | 2010-01-12 05:51:18 | Re: how much left for restore? |
Previous Message | AI Rumman | 2010-01-12 05:40:07 | Re: location for pg_default tablespace |