I moved all tables and indices out of a tablespace to a different tablespace (different hard drive and different mountpoint). Now I want to drop the old tablespace but it says the tablespace is not empty.
If I go into the tablespace directory i see bunch of files. I was told that these cannot be deleted, but if I'm trying to drop this tablespace anyway, can I just delete these files? Will this affect the tables that are moved to the new tablespace
Expand|Select|Wrap|Line Numbers
- <code>PG_9.5_201510051/259388 # du -sh *
- 1.1G 2935335227
- 1.1G 2935335227.1
- 1.1G 2935335227.2
- 138M 2935335227.3
- 1.1G 2935335230
- 1.1G 2935335230.1
- 1.1G 2935335230.2
- 1.1G 2935335230.3
- 1.1G 2935335230.4
- 1.1G 2935335230.5
- 266M 2935335230.6
- 139M 2935335232</code>
Thanks in advance