8.1.3 and unused files - Mailing list pgsql-hackers

From Rod Taylor
Subject 8.1.3 and unused files
Date
Msg-id 1146851586.8325.30.camel@home
Whole thread Raw
Responses Re: 8.1.3 and unused files
List pgsql-hackers
Am I correct in the thought that the various files listed below are not
used by the database and can be safely removed? There were no other
active db connections when I issued this command.

I think truncate (Slony) left them behind.

ssdb=# select filefrom pg_ls_dir('base/'|| (select oid from pg_database where datname =
'ssdb')) as tab(file) where file !~ '\\..*$'and file not in (select relfilenode from pg_class)and file not in
('PG_VERSION','pgsql_tmp');
 
 file
---------143498614349841434985
(3 rows)

[root@DB1 16384]# ls -la 143498[456]*
-rw-------   1 rbt      sysadmin 1073741824 May  1 20:56 1434984
-rw-------   1 rbt      sysadmin 1073741824 May  1 21:11 1434984.1
-rw-------   1 rbt      sysadmin 1073741824 May  1 23:21 1434984.10
-rw-------   1 rbt      sysadmin 1073741824 May  1 23:36 1434984.11
-rw-------   1 rbt      sysadmin 1073741824 May  1 23:50 1434984.12
-rw-------   1 rbt      sysadmin 1073741824 May  2 00:06 1434984.13
-rw-------   1 rbt      sysadmin 1073741824 May  2 00:23 1434984.14
-rw-------   1 rbt      sysadmin 1073741824 May  2 00:39 1434984.15
-rw-------   1 rbt      sysadmin 1073741824 May  2 00:57 1434984.16
-rw-------   1 rbt      sysadmin 1073741824 May  2 01:14 1434984.17
-rw-------   1 rbt      sysadmin 1073741824 May  2 01:31 1434984.18
-rw-------   1 rbt      sysadmin 1073741824 May  2 01:50 1434984.19
-rw-------   1 rbt      sysadmin 1073741824 May  1 21:25 1434984.2
-rw-------   1 rbt      sysadmin 1073741824 May  2 02:07 1434984.20
-rw-------   1 rbt      sysadmin 1073741824 May  2 02:23 1434984.21
-rw-------   1 rbt      sysadmin 1073741824 May  2 02:41 1434984.22
-rw-------   1 rbt      sysadmin 1073741824 May  2 02:55 1434984.23
-rw-------   1 rbt      sysadmin 1073741824 May  2 03:09 1434984.24
-rw-------   1 rbt      sysadmin 1073741824 May  2 03:24 1434984.25
-rw-------   1 rbt      sysadmin 1073741824 May  2 03:37 1434984.26
-rw-------   1 rbt      sysadmin 1073741824 May  2 03:53 1434984.27
-rw-------   1 rbt      sysadmin 1073741824 May  2 04:09 1434984.28
-rw-------   1 rbt      sysadmin 1073741824 May  2 04:24 1434984.29
-rw-------   1 rbt      sysadmin 1073741824 May  1 21:40 1434984.3
-rw-------   1 rbt      sysadmin 1073741824 May  2 04:40 1434984.30
-rw-------   1 rbt      sysadmin 1073741824 May  2 04:56 1434984.31
-rw-------   1 rbt      sysadmin 990912512 May  2 05:09 1434984.32
-rw-------   1 rbt      sysadmin 1073741824 May  1 21:54 1434984.4
-rw-------   1 rbt      sysadmin 1073741824 May  1 22:08 1434984.5
-rw-------   1 rbt      sysadmin 1073741824 May  1 22:23 1434984.6
-rw-------   1 rbt      sysadmin 1073741824 May  1 22:36 1434984.7
-rw-------   1 rbt      sysadmin 1073741824 May  1 22:52 1434984.8
-rw-------   1 rbt      sysadmin 1073741824 May  1 23:07 1434984.9
-rw-------   1 rbt      sysadmin    8192 May  1 20:40 1434985
-rw-------   1 rbt      sysadmin 1073741824 May  2 11:27 1434986
-rw-------   1 rbt      sysadmin 1073741824 May  2 11:39 1434986.1
-rw-------   1 rbt      sysadmin 121733120 May  2 16:53 1434986.10
-rw-------   1 rbt      sysadmin 1073741824 May  2 11:56 1434986.2
-rw-------   1 rbt      sysadmin 1073741824 May  2 12:15 1434986.3
-rw-------   1 rbt      sysadmin 1073741824 May  2 12:43 1434986.4
-rw-------   1 rbt      sysadmin 1073741824 May  2 13:15 1434986.5
-rw-------   1 rbt      sysadmin 1073741824 May  2 13:53 1434986.6
-rw-------   1 rbt      sysadmin 1073741824 May  2 14:35 1434986.7
-rw-------   1 rbt      sysadmin 1073741824 May  2 15:38 1434986.8
-rw-------   1 rbt      sysadmin 1073741824 May  2 16:53 1434986.9
-- 



pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC
Next
From: "Magnus Hagander"
Date:
Subject: Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC