Search Postgresql Archives

Re: location for pg_default tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx  www.2ndQuadrant.com


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux