My postgresql instance was last started on Apr21.
In my temp space directory, I have various files that I believe are orphaned.
Given the information below, can I safely rm the files in /mnt/iscsi/psql_tmp/tmpdata/41099 that are older than Jun 22?
If yes, should these files have been cleaned up by the restart on Apr21?
If yes, if I restart the DB today/in the next few days and the files from Jun 22 remain after the restart, can I safely
rmthem?
thanks,
reid
reporting=# \db
List of tablespaces
Name | Owner | Location
------------+----------+-----------------------------
indexspace | postgres | /mnt/iscsi/psql_idx/idxdata
pg_default | postgres |
pg_global | postgres |
tempspace | postgres | /mnt/iscsi/psql_tmp/tmpdata
postgres@hw-prod-repdb1> ps -ef|grep postg |grep -v idle
postgres 19895 1 0 Apr21 ? 00:05:19 /usr/bin/postmaster -p 5432 -D /mnt/iscsi/psql/data
postgres 19903 19895 0 Apr21 ? 00:00:10 postgres: logger process
postgres 19906 19895 0 Apr21 ? 00:10:34 postgres: writer process
postgres 19907 19895 0 Apr21 ? 00:02:04 postgres: wal writer process
postgres 19908 19895 0 Apr21 ? 00:08:42 postgres: stats collector process
root 21228 16899 0 08:08 pts/4 00:00:00 su - postgres
postgres 21230 21228 0 08:08 pts/4 00:00:00 -bash
postgres 24485 21230 0 10:02 pts/4 00:00:00 ps -ef
postgres 24486 21230 0 10:02 pts/4 00:00:00 grep postg
postgres@hw-prod-repdb1> pwd
/mnt/iscsi/psql_tmp/tmpdata/41099
postgres@hw-prod-repdb1> ls -rlt
total 3044944
-rw------- 1 postgres postgres 8192 Mar 12 2010 88326
-rw------- 1 postgres postgres 0 Mar 12 2010 88324
-rw------- 1 postgres postgres 0 Mar 16 2010 88580
-rw------- 1 postgres postgres 0 Mar 16 2010 88577.3
-rw------- 1 postgres postgres 0 Mar 16 2010 88577.4
-rw------- 1 postgres postgres 0 Mar 16 2010 88577.5
-rw------- 1 postgres postgres 8192 Mar 16 2010 88592
-rw------- 1 postgres postgres 8192 Jun 2 2010 94968
-rw------- 1 postgres postgres 0 Jun 2 2010 94966
-rw------- 1 postgres postgres 8192 Jun 2 2010 94974
-rw------- 1 postgres postgres 0 Jun 2 2010 94972
-rw------- 1 postgres postgres 8192 Aug 26 2010 104559
-rw------- 1 postgres postgres 0 Aug 26 2010 104557
-rw------- 1 postgres postgres 1073741824 Oct 27 2010 88577
-rw------- 1 postgres postgres 1073741824 Oct 27 2010 88577.1
-rw------- 1 postgres postgres 862986240 Oct 27 2010 88577.2
-rw------- 1 postgres postgres 499712 Nov 2 2010 111724
-rw------- 1 postgres postgres 44523520 Dec 7 2010 94963
-rw------- 1 postgres postgres 25657344 Dec 7 2010 94969
-rw------- 1 postgres postgres 33628160 Jun 22 18:46 88321
-rw------- 1 postgres postgres 16384 Jun 22 19:49 104560
-rw------- 1 postgres postgres 16384 Jun 22 19:49 104554
