Hi Tom,
And how can this automatically be changed if Germany switches from
summer time (CEST with +0200) to winter time (CET +0100)?
Well, you could write <+0200>-2<+0100> but I'm not sure I would recommend
it. That would result in switching on the DST transition days specified
in the "posixr
- Nachricht von Adrian Klaver -
Datum: Tue, 22 Sep 2015 07:46:24 -0700
Zone names: Time zone names ('z') cannot be parsed.
Some more digging found that DateTimeFormat can deal with Z which
is either the offset or the timezone id, in particular as ZZZ.
http://joda-time.sour
Hi Tom,
Michael Zoet writes:
Is there a way to convince Postgres to write the date/time with
numerical time zone values to the log files?
Try something like
log_timezone = '<-0400>+4'
OK this points me in a directions I haven't read anything about in the
Postgres
On 09/22/2015 06:31 AM, Michael Zoet wrote:
Hi Charles,
thanks for the quick response and it looked promising but did not work
as expected.
I can set the datestyle to ISO on database level but this does not seem
to effect the way the CSV logs are written. I still get 2015-09-22
13:06:01.658
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Michael Zoet
Sent: Dienstag, 22. September 2015 12:07
To: pgsql-general@postgresql.org
Subject: [GENERAL] how to show time zone with numerical offset in CSV log?
Hello everybody,
I am saving PostgreSQL log file data (CVS logs) with Logstash
Hello everybody,
I am saving PostgreSQL log file data (CVS logs) with Logstash and
Elasticsearch. My problem with this is that the time zone value is
with the name of the time zone like
2015-09-22 12:02:59.836 CEST
which Logstash can not process.
What Logstash needs are date/time stamps
