* Scott Whitney wrote:
Everything you need to see is right here:
[root@<serverNameRemoved> pg_log]# ls -lrt
total 5924
-rw------- 1 postgres postgres 708669 Aug 8 18:59 postgresql-Thu.log
-rw------- 1 postgres postgres 669505 Aug 9 18:59 postgresql-Fri.log
-rw------- 1 postgres postgres 666603 Aug 10 18:56 postgresql-Sat.log
-rw------- 1 postgres postgres 559716 Aug 11 18:59 postgresql-Sun.log
-rw------- 1 postgres postgres 626143 Aug 12 18:56 postgresql-Mon.log
-rw------- 1 postgres postgres 2065282 Aug 13 18:24 postgresql-Tue.log
-rw------- 1 postgres postgres 755099 Aug 13 19:22 postgresql-Wed.log
[root@<serverNameRemoved> pg_log]# date
Tue Aug 13 19:23:53 CDT 2013
log_timezone is set to UTC, which is normally six hours ahead of
Chicago, but does not observe DST, so currently it is five hours ahead.
18:24 plus five is still the same day, 19:22 plus five is the next day.
Quoting the docs:
log_timezone (string)
Sets the time zone used for timestamps written in the server log. Unlike
TimeZone, this value is cluster-wide, so that all sessions will report
timestamps consistently. The built-in default is GMT, but that is
typically overridden in postgresql.conf; initdb will install a setting
there corresponding to its system environment.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
