From: | Rod Taylor <pg(at)rbt(dot)ca> |
---|---|
To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | 8.1.3 and unused files |
Date: | 2006-05-05 17:53:06 |
Message-ID: | 1146851586.8325.30.camel@home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 file
from 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
---------
1434986
1434984
1434985
(3 rows)
[root(at)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
--
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2006-05-05 18:02:23 | Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC |
Previous Message | Magnus Hagander | 2006-05-05 17:46:42 | Re: [pgsql-hackers-win32] Build with Visual Studio & MSVC |