X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2773B329C65 for ; Tue, 19 Oct 2004 17:13:05 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49019-03 for ; Tue, 19 Oct 2004 16:13:00 +0000 (GMT) Received: from outbound3.mail.tds.net (outbound3.mail.tds.net [216.170.230.93]) by svr1.postgresql.org (Postfix) with ESMTP id 872D8329E65 for ; Tue, 19 Oct 2004 17:12:53 +0100 (BST) Received: from tds.net (h69-128-145-125.69-128.unk.tds.net [69.128.145.125]) by outbound3.mail.tds.net (8.12.10/8.12.2) with ESMTP id i9JGCjhh008063 for ; Tue, 19 Oct 2004 11:12:49 -0500 (CDT) Message-ID: <41753D3F.1020204@tds.net> Date: Tue, 19 Oct 2004 11:13:51 -0500 From: Bryan Biggers User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pgsql database .1 .2 .3 file names Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/245 X-Sequence-Number: 15238 Can anyone tell me what the data file names with the .1 .2 .3 etc. extensions are? Are these undo versions of my tables or something? I need to recover some disk space and I'm wondering if I need them. Here is an example... -rw------- 1 postgres postgres 1073741824 Oct 18 20:01 19523580 -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.1 -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.2 -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.3 -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.4 -rw------- 1 postgres postgres 1073741824 Oct 6 20:19 19523580.5 -rw------- 1 postgres postgres 629948416 Oct 19 12:33 19523580.6 Thanks, Bryan