9.1 QUestion -- directory left over after drop database

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

 



I have been playing a bit with a 9.1 instance as we plan for some new data.

I created a database in a tablespace:

  CREATE DATABASE foo2test2 TEMPLATE template1 TABLESPACE data1;

I set my default tablesapce and create a dummy table with a small amount of data:
  SET default_tablespace = data1;
  CREATE TABLE testx(d_id serial not null,d_text text,d_val integer);
  CREATE INDEX testx ON dingbats (d_id);
  INSERT INTO testx VALUES (22,'A test value');
  INSERT INTO testx VALUES(1011,'Another test value');

This created two new directories in my data1 tablespace:
-bash-3.2$ ls -lrt
total 40
drwx------ 2 postgres postgres 4096 Jan 16 10:13 1262754833
drwx------ 2 postgres postgres 4096 Jan 17 09:40 1262752970
drwx------ 2 postgres postgres 4096 Jan 26 19:08 1848319667
drwx------ 2 postgres postgres 4096 Jan 27 11:30 1262751111
drwx------ 2 postgres postgres 4096 Jan 27 15:12 979045183
drwx------ 2 postgres postgres 4096 Jan 31 16:37 3891138239
drwx------ 2 postgres postgres 4096 Jan 31 17:45 3891099801
drwx------ 2 postgres postgres 4096 Feb  6 10:14 941593524
drwx------ 2 postgres postgres 4096 Feb  6 14:38 1577008279   <-- the database itself
drwx------ 2 postgres postgres 4096 Feb  6 14:38 12698            <-- my little table

If I drop the database as a whole this 12698 directory is left in place but is empty.

If I drop just the table the directory is left with 0 length files:
-bash-3.2$ ls -lrt 12698
total 0
-rw------- 1 postgres postgres 0 Feb  6 14:49 1577013889
-rw------- 1 postgres postgres 0 Feb  6 14:49 1577011574
-rw------- 1 postgres postgres 0 Feb  6 14:49 1577011572
-rw------- 1 postgres postgres 0 Feb  6 14:49 1577011568

Are these safe to delete these files ?

Is it safe to delete the directory itself ?

Thanks,

Greg Williamson
DBA 
Powerreviews.com

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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux