"Andrew Crouch" <s4011726(at)student(dot)uq(dot)edu(dot)au> writes:
> -rw------- 1 postgres dbadmin 122880 Oct 18 13:28 1269 <-- What is this
> file
pg_log, as you could find out with an inquiry against pg_class:
test71=# select relname from pg_class where relfilenode = 1269;
relname
---------
pg_log
(1 row)
test71=#
No, you can't delete it or shorten it, except by dump/initdb/reload.
7.2 will have a better approach to pg_log maintenance ...
regards, tom lane