pg_temp files in the database dirs - Mailing list pgsql-general

From George Henson
Subject pg_temp files in the database dirs
Date
Msg-id 39885042.4212574F@tcinet.net
Whole thread Raw
List pgsql-general
I am running [PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc
2.7.2.3]

I looked into the $PGDATA/base/$DBNAME dirs and there are some pg_temp
files.

This would not normaly raise a question, but they are in the order of
100's of megs and there ctime is from May. I have found these in almost
all of my database dirs.

What are these files from? and how does one clean them up? Is this a
normal thing to happen?

Thank you

pgsql-general by date:

Previous
From: "David Lloyd-Jones"
Date:
Subject: Is There Anybody in Toronto Running Postgresql with AOLserver?
Next
From: Martyn Wilson
Date:
Subject: image data-types