Large Files? - Mailing list pgsql-general

From Andrew Crouch
Subject Large Files?
Date
Msg-id NDBBKFCDMKJKLPCAHLPHOEGPCCAA.s4011726@student.uq.edu.au
Whole thread Raw
Responses Re: Large Files?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

[postres@kc131-161 /usr/local/opt/Postgres/data/global]# ls -la
total 170
drwx------  2 postgres  dbadmin     512 Oct 15 18:09 .
drwx------  5 postgres  dbadmin     512 Oct 15 18:00 ..
-rw-------  1 postgres  dbadmin    8192 Oct 15 18:10 1260
-rw-------  1 postgres  dbadmin       0 Oct 15 17:59 1261
-rw-------  1 postgres  dbadmin    8192 Oct 18 13:00 1262
-rw-------  1 postgres  dbadmin       0 Oct 15 17:59 1264
-rw-------  1 postgres  dbadmin  122880 Oct 18 13:28 1269
-rw-------  1 postgres  dbadmin    8192 Oct 15 17:59 17127
-rw-------  1 postgres  dbadmin    8192 Oct 15 17:59 17130
-rw-------  1 postgres  dbadmin    8192 Oct 18 13:28 pg_control
-rw-------  1 postgres  dbadmin       0 Oct 15 18:09 pg_pwd
-rw-------  1 postgres  dbadmin       0 Oct 15 18:08 pg_pwd.reload


-rw-------  1 postgres  dbadmin  122880 Oct 18 13:28 1269   <-- What is this
file


Im running a fairly heavy database application, this file grew in size to

-rw------- 1 postgres dbadmin 961904640 Oct 15 16:18 1269

over a period of 2-3 months?


Failing everything, I backed up the database, upgraded postgres and reloaded
the database only to see this file popup again.  Can i safely delete this
file? What is it? Do i need it ?

Regards
Andrew


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: To Postgres Devs : Wouldn't changing the select limit
Next
From: "Brett W. McCoy"
Date:
Subject: Re: SQL equivallent to "\ds" in psql