8.1.3 and unused files
| От | Rod Taylor |
|---|---|
| Тема | 8.1.3 and unused files |
| Дата | |
| Msg-id | 1146851586.8325.30.camel@home обсуждение исходный текст |
| Ответы |
Re: 8.1.3 and unused files
|
| Список | 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 по дате отправления: