pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Williamson <gwilliamson39@yahoo.com>
To: Matheus de Oliveira <matioli.matheus@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgres 9.0 date aberration in logs
Date: Tue, 7 Feb 2012 12:39:48 -0800 (PST)
Message-ID: <1328647188.16397.YahooMailNeo@web46113.mail.sp1.yahoo.com> (raw)
In-Reply-To: <CAJghg4KRhB+LH6p_5x1yTANOG=uabxNu6y6Oo3_i-7gjDUOUbw@mail.gmail.com>
References: <1328640207.42210.YahooMailNeo@web46103.mail.sp1.yahoo.com>
	<CAJghg4KRhB+LH6p_5x1yTANOG=uabxNu6y6Oo3_i-7gjDUOUbw@mail.gmail.com>

Matheus --

>
>To me seems that it just appended the data to your log. To avoid this set the log_truncate_on_rotation to on, but notice that it will replace the old logs.
>
>


Thanks for the suggestion, but we seem to be using this already:

-bash-3.2$ grep  log_truncate_on_rotation  postgresql.conf
log_truncate_on_rotation = on# If on, an existing log file of the

Is it possible that this fails under some conditions ? 

We are migrating to 9.1, which unfortunately showed the same issues at almost the same time; no complaints in system logs or restarts of the servers.

Very odd ...

Greg W.




view thread (3+ messages)

Message-ID: <1328647188.16397.YahooMailNeo@web46113.mail.sp1.yahoo.com>
Permalink:  ../1328647188.16397.YahooMailNeo@web46113.mail.sp1.yahoo.com/
Also on:    postgresql.org/message-id/1328647188.16397.YahooMailNeo@web46113.mail.sp1.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gwilliamson39@yahoo.com, matioli.matheus@gmail.com
  Subject: Re: postgres 9.0 date aberration in logs
  In-Reply-To: <1328647188.16397.YahooMailNeo@web46113.mail.sp1.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox