El mié, 03-02-2010 a las 15:12 -0600, Campbell, Lance escribió: > PostgreSql:8.4.1 > > Is there a way for me to tell postgres to clear the log file. > Example: I have log files created with names corresponding to the > days of the week. This way they overwrite each other every week. > When I deploy software enhancements I would like to clear the log file > for the day without having to stop postgres. This way anything I see > I know was after the deployment of my enhancements. I tried to just > delete the file with postgres running. I found that it did not > recreate the log file so I was forced to restart postgres. > Actually, when you delete an opened file it isn't really deleted. Whatever program opened it can still read/write to it using the file descriptor. > Is there a command that might clear a log file or force it to rotate? Truncating it like this should work: echo > /path/to/logfile There's probably a better way though. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
