Re: location for pg_default tablespace

AI Rumman wrote:
> I used the followings:
>
> create tablespace mytabspc location '/var/lib/pgsql/data/pg_tblspc';
>
> create database mydb with tablespace=mytabspc;
>
> drop database mydb;
>
> drop tablespace mytabspc;
> ERROR: tablspace 'mytabspc' is not empty
>
> Please tell me why?

You don't put things in pg_tblspace yourself; that directory is for the
database to manage.  Your tablespace should be somewhere completely
outside of /var/lib/pgsql/data altogether.

--
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com