ray wrote:
While debugging applications interacting with pg, the log file (under pg_log) gets quite long. The log file typically has a name such as postgresql-2009-05-26_000000.log; sometimes an new file will be generated on the same day and the portion of the name that is all zeroes will change to a larger number for each change during that day. I would like to know what triggers the name change and how can I force a change.
by default, a new log is created at midnight (hence the _000000) and when the server is restarted (which would have a timestamp related to when it was restarted)
you can force a new logfile with... SELECT |pg_rotate_logfile|(); -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
