Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 1B6D91F32A41 for ; Mon, 6 Feb 2012 18:58:09 -0400 (AST) Received: from nm10-vm0.bullet.mail.sp2.yahoo.com ([98.139.91.198]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1RuXUi-0006P0-Bm for pgsql-admin@postgresql.org; Mon, 06 Feb 2012 22:57:09 +0000 Received: from [98.139.91.62] by nm10.bullet.mail.sp2.yahoo.com with NNFMP; 06 Feb 2012 22:56:54 -0000 Received: from [72.30.22.33] by tm2.bullet.mail.sp2.yahoo.com with NNFMP; 06 Feb 2012 22:55:53 -0000 Received: from [127.0.0.1] by omp1061.mail.sp2.yahoo.com with NNFMP; 06 Feb 2012 22:55:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 974435.21109.bm@omp1061.mail.sp2.yahoo.com Received: (qmail 37614 invoked by uid 60001); 6 Feb 2012 22:55:53 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1328568953; bh=O0u80UAGQ8egpSsreD8y860NgiOqZOt9d4eu3U4XY+8=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=D/olyv9upfxGP+c9At1Vna1mQXXvm3URYeft1clKAQpdIGQm4sCziY2dXO7K+e1xxgRUnvsa16qAiqhWsRwWZOc4W6Gxr6iftbfMUNgEngI4nCBssMFdNjAcU+NrHiEXOKT96dscN5z4G2ubJl4cTET85j6ZbpYERUM6MynZ1LY= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Vc5dBb8BbwKjqCSPBOLK4WeVSVuFc0yfIUR1bv3NFgGgvJlFCYmhBO2z9yUomrb7b0JAKkLdsexa06AXqiydZReP+fSMGttkkqBzNd7kqWtfUJ601CgVUzzkRaf0L+6L7nw5RI31JtF9+p4C0BY+7+hdtQEdd8/f5XtJt5rg0A0=; X-YMail-OSG: cVmDIjoVM1kXJmPGynEc1GM2TpnAGd2Igti_p0nRbGdF7gq VD5.Jqq2Q7F3YKywl_8T9V_u6EwSSaw.Q95KLGzl1iR8ahBE3jKEr5F26JuF y0re5Xg6uCmNYtkb9ITuJ2dBXsxb9GylmU7o3Jr.h_gBxEiRhJgvm9RRWypO pMw7Pi_RkBXZXXFzCczhEY0K.vo.8HZinf_jOizISzLniALdMjPyn7qb9MJ0 sb9nmJphkHjXulv02kgrxDCk0LAVY88RPGIdBtQQX0Vu_DSUB3MYauoalNZh EoAR2BoyNpPNHuFVRptAtvity.mcWm1Cu4c9C7FN_wCRdv8w.CXesSueCrjK _k_G617ZtB5SAZtGbPcIO7S7.kGxAGLtAtXUpaVv_k762jF4exe09_j3v4Ip zp1A08KbTRTzs0cWVci1162y4MDYSSii8QxBzXUGfjfuH6LJDREwvM0aPz_i FmhOZMAbux3navtu4ZutV2eM- Received: from [206.80.5.2] by web46113.mail.sp1.yahoo.com via HTTP; Mon, 06 Feb 2012 14:55:53 PST X-Mailer: YahooMailWebService/0.8.116.338427 Message-ID: <1328568953.37574.YahooMailNeo@web46113.mail.sp1.yahoo.com> Date: Mon, 6 Feb 2012 14:55:53 -0800 (PST) From: Greg Williamson Reply-To: Greg Williamson Subject: 9.1 QUestion -- directory left over after drop database To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.5 (-) X-Archive-Number: 201202/40 X-Sequence-Number: 39100 I have been playing a bit with a 9.1 instance as we plan for some new data.= =0A=0AI created a database in a tablespace:=0A=0A=A0=A0CREATE DATABASE foo2= test2 TEMPLATE template1 TABLESPACE data1;=0A=0AI set my default tablesapce= and create a dummy table with a small amount of data:=0A=A0 SET default_ta= blespace =3D data1;=0A=A0=A0CREATE TABLE testx(d_id serial not null,d_text = text,d_val integer);=0A=A0=A0CREATE INDEX testx ON dingbats (d_id);=0A=A0 I= NSERT INTO testx VALUES (22,'A test value');=0A=A0 INSERT INTO testx VALUES= (1011,'Another test value');=0A=0AThis created two new directories in my da= ta1 tablespace:=0A-bash-3.2$ ls -lrt=0Atotal 40=0Adrwx------ 2 postgres pos= tgres 4096 Jan 16 10:13 1262754833=0Adrwx------ 2 postgres postgres 4096 Ja= n 17 09:40 1262752970=0Adrwx------ 2 postgres postgres 4096 Jan 26 19:08 18= 48319667=0Adrwx------ 2 postgres postgres 4096 Jan 27 11:30 1262751111=0Adr= wx------ 2 postgres postgres 4096 Jan 27 15:12 979045183=0Adrwx------ 2 pos= tgres postgres 4096 Jan 31 16:37 3891138239=0Adrwx------ 2 postgres postgre= s 4096 Jan 31 17:45 3891099801=0Adrwx------ 2 postgres postgres 4096 Feb = =A06 10:14 941593524=0Adrwx------ 2 postgres postgres 4096 Feb =A06 14:38 1= 577008279 =A0 <-- the database itself=0Adrwx------ 2 postgres postgres 4096= Feb =A06 14:38 12698 =A0 =A0 =A0 =A0 =A0 =A0<-- my little table=0A=0AIf I = drop the database as a whole this 12698 directory is left in place but is e= mpty.=0A=0AIf I drop just the table the directory is left with 0 length fil= es:=0A-bash-3.2$ ls -lrt 12698=0Atotal 0=0A-rw------- 1 postgres postgres 0= Feb =A06 14:49 1577013889=0A-rw------- 1 postgres postgres 0 Feb =A06 14:4= 9 1577011574=0A-rw------- 1 postgres postgres 0 Feb =A06 14:49 1577011572= =0A-rw------- 1 postgres postgres 0 Feb =A06 14:49 1577011568=0A=0AAre thes= e safe to delete these files ?=0A=0AIs it safe to delete the directory itse= lf ?=0A=0AThanks,=0A=0AGreg Williamson=0ADBA=A0=0APowerreviews.com