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(at)2ndQuadrant(dot)com www.2ndQuadrant.com